Table will not open in datasheet view, 'Invalid Argument', why?

H

HaringeyMike

lOne of our nurse teams has a small access appication which has run for about
a year. Suddenly the main table will not open giving the 'Invalid Argument'
message. Has anybody any thoughts?
 
O

Ofer

Did you try running compact and repair on the MDB where the table located?
If not try it, but please back up first

Also are you sure its a table and not a query, it can be easily mistaken.
 
J

John Vinson

lOne of our nurse teams has a small access appication which has run for about
a year. Suddenly the main table will not open giving the 'Invalid Argument'
message. Has anybody any thoughts?
Click to expand...

Either this is a Form or Query rather than a table (you shouldn't be
routinely opening table datasheets in a well-designed database); or
the database is corrupt. BACK IT UP, NOW - don't overwrite any
existing backups when you do so, you may need both old and new
backups.

Then check out the suggestions at

http://www.granite.ab.ca/access/corruptmdbs.htm

John W. Vinson[MVP]
 
Top