File Size

C

CJL

It appers I have exceeded the file size as my database is at 1.99GB. When I
attempt to delete tables out I am getting error messages. I also get
messages when I attempt to compacts. Any suggestions?
 
D

Damien McBain

CJL said:
It appers I have exceeded the file size as my database is at 1.99GB.
When I attempt to delete tables out I am getting error messages. I
also get messages when I attempt to compacts. Any suggestions?
Click to expand...

SQL or Oracle
 
D

Dirk Goldgar

CJL said:
It appers I have exceeded the file size as my database is at 1.99GB.
When I attempt to delete tables out I am getting error messages. I
also get messages when I attempt to compacts. Any suggestions?
Click to expand...

Try creating a new blank database, and importing those tables you want
to keep from the original database, along with all the other objects.
If the size of the new database, after importing what you want, exceeds
about 1.5GB, you're going to need to either shift your tables into some
higher-volume database system (such as SQL Server), or split them among
several different Access MDB files and link to them from the front-end
database that contains your queries, forms. reports, etc.
 
Top