If anyone can provide advise on this topic it would be much appreciated - I work extensively with MSAccess 97 - one truly inefficient aspect which I wish to get to the bottom of relates to the mb taken up by active databases. The size keeps increasing requiring continual compacting - is there maintenance I can perform to overcome this feature ???
Many thanks
Eunan
This conversation is currently closed to new comments.
Repairing and compacting is the maintenance you do to deal with this aspect of Access databases Look up compacting databases for general info on the topic and CompactDatabase for an example ofhow this can be done in code. Hope this helps John
There is an Access feature that allows "Admin" to set Access up so it will "Compact" automatically whenever it is closed. ALL databases act the same way once this application property is set while NO databases are open. Repeat the process on any machine, or on the server + once on each front-end machine.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
MS Access Database Compacting
much appreciated -
I work extensively with MSAccess 97 - one truly inefficient aspect
which I wish to get to the bottom of relates to the mb taken
up by active databases. The size keeps increasing requiring
continual compacting - is there maintenance I can perform
to overcome this feature ???
Many thanks
Eunan