my access database is greater than 2 GB. now when i run a make table
queries- i get this error- " Invalid argument". what should i do. When
i compact the database it gives some error like "sqltable already
available"
What should i do. any help appreciated
You're in trouble: I hope you have a current backup!!!
Create a new, empty database. Use File... Get External Data... Import to
import - first - all the forms, reports, queries, macros and modules from your
current database.
Then create a second database and import all the tables.
Open the former database and use File... Get External Data... Link to link to
the database containing the tables. This will give you a properly "split"
application, with the tables in a backend file and everything else in a
frontend.
This may or may not work, depending on whether your attempt to compact an
un-backedup database irreversibly corrupted and destroyed it, as is quite
possible. Good luck.
Do you actually have over 2Gig *OF DATA*? Or do you have graphical images in
your tables? (Up to A2007 Access handled graphics very inefficiently).
