Won't compact database with linked tables

[Navel12]

I have an Access database that sits on the server. On the local side sits an Access database which is linked to the server database. I only open the local database to retreive data. I have the server database set to compact on close yet when the application ends the server database will not automatically compact. Any suggestions?

 

[bubba100]

I believe that just because you have linked to does not mean you have opened the db on the your server. Does the one on the server compact when you close after manually opening?

 

[Navel12]

thanks for the reply. Yes, if I open the db on the server manually it does compact. Is this the problem? Do I just need to access the db directly at some point to get it to compact on close?

 

[bubba100]

You could do that. How many people use the db? If there is a time you know no one will be using the db you could schedule the opening of another db that would compact the backend db. There have been numerious discussions in tek-tips about various ways of compacting.