Compact on close

[insanemom]

I have a split database in which the backend is located on the server and several users have the frontend on their hard drives.

Forms in frontend file have combo boxes whose control sources are tables in the backend file. The combo boxes seem to be losing their connections to the backend file.

If I compact and repair the frontend file, the issue is resolved. The user has to save the repaired file over the "corrupted" one, and all is well.

I would like to add a command button so the user can perform this function when he has this error. I know very little code, so I'm hoping someone can help me.

I'm aware of the "compact on close" option, but am concerned about whether the backend file is affected. Because it's multiuser environment, I have read that compacting the backend when it's open can corrupt the file.

Or...if there's a better solution to solving the issue, any advice is greatly appreciated!

 

[ypma]

Compacting the front end does not effect the back end, only the users front end . You can set the compact on close option and each time your front end closes it will compact. If you are unsure how to do this let me know what version you are using and i will assist you . Just notice you are aware of the compact on close option .

 

[mdlueck]

Or...if there's a better solution to solving the issue

I utilize a disposable FE file. I have scripted basically RoboCopy delivers the FE file from the file server to the node to a "staging" file name, followed up by XCopy of the staging file name to the production file name.

This way:

1) Reduce network bandwidth not deploying the FE each time, beneficial for remote VPN clients
2) Provides a fresh FE file each time the application is started

I use this process when preparing an FE for deployment:

NT Command Script and Documented Steps to Decompile / Compact / Compile an Access DB
http://www.access-programmers.co.uk...to_Decompile_/_Compact_/_Compile_an_Access_DB

 

[emorris1000]

Cloning the FE works for me as well, it's pretty straightforward and makes version control wayyyyyyy easier.