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

[Guest]

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?

 

[Guest]

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.

 

[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?

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]