Invalid argument "lock"

  • Thread starter Thread starter ralph
  • Start date Start date
R

ralph

Somehow in runnng a query I came up with an error that
states I have an Ivalid Argument. This seems to have
locked up the database, I can't copy a table, process any
query or do anything with out the Invalid argument error
showing up and the process I am trying to do is aborted.
This is also true when I try to compact and repair the
database to a new name. I even tried a new database with
a link to the "bad" database to tried to append data (just
to retrieve it) but same message. I also tried exporting
the data to a .txt file that I could load into a new
Database but it created a large file that had no data.
Does anyone have any suggestion how I can fix the
database --or-- just retrieve the data???
THANKS!!!!!
 
Ralph -

I get this error when my database gets too large. Your
database may be suffering from database "bloat", where if
you run multiple "make table" queries, your database can
artificially puff up. If it gets larger than 2Gig (? -
200 MG? I know it's 2 - something), then you get this
error. Compact and repair can sometimes help, but if the
database is too big to start with, you may be out of
luck. I've had to split my data into multiple databases
(ie, first 1M records in the one DB, next 1M records in
the next).

Or, it may be an Access bug. If you are running on
Access 2000, there is a patch for this. Search
on "Invalid Argument" or "database bloat" in this
website...

Hope this helps.

K
 
Back
Top