File Size

[Guest]

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?

 

[Damien McBain]

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?

SQL or Oracle

 

[Dirk Goldgar]

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?

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.