Search results

Thanks everyone for the replies. I am look into different suggestions especially the temp table. But in the meantime I will continue trying to compact and repair. Thanks again for your suggestions.

When it gets to big it is way to slow on the VPN that is why. Is there any other option than compact because users are always in the database. Can I program something

It is hard to do that because the database is open most of the time so I can't get a pack and repair automatically on closing. Do you have any suggestion of things I could do. I am willing to change the database if needed.

More info. I am not really sure. It is an access database on a server that is accessed through VPN and also on the network by different users. Not SQL that is for sure but I am not sure what the other option is. Thanks for giving me a hand.

Hi I really need help with this. I have a database that is quite large and is accessed through VPN. When I shrink and compact the database it goes to a respectable size. But over time everytime a report is previewed the size of the database grows. Or every access it grows to double its size...