table does not open

[Shai]

Hello,

i have a very large table in an Access database.


whenever i try to open it gives an error saying "the query cannot be completed. Either the size of the result is larger than the maximum size of a database (2GB), or there is not enough temporary storage space on the disk to store the query result"

the reason that i tried to open the table was to erase a large portion of it since the queries to this table were very slow, but if i can't open it, i can't delete anything.

does anyone know how i can regain access to the query?

thanks

[ranman256]

you may have waited too long to correct it.
try compacting the db, it may help.
make a query to delete items you know exist without opening the table: delete * from table where [name]="", then run the delete, and compact.

If it starts getting to the 1.1 Gig range you may want to start thinking about more external tables to help keep the size down.
1 db for historical data and 1 for current.

compact often.