H
Hammy
Guest
In the esteemed opinion of those here, what is the best way to handle the following senario (I have done some research and can't seem to find a good solution, so now I am here where I have recieved A+ help!)....
I have a db split into a front end file with forms,queries and reports and a back end file with the linked tables (for network speed). I am not overly concerned about running regular compact/repairs on the front end, however I want to implement a solution to regularly compact and repair the backend tables.
I would like to put in some solution that allows the user to simply click a button on the switchboard that will perform the compact on the linked tables file, at their discression. However, I can't determine how to set this up....and know it is working and will work in a multi user environment.
The only other option I can see is to enable compact on close for the backend file. However, I am not certain how this would react in a multi user network environment.
Any suggestions?
Hammy
I have a db split into a front end file with forms,queries and reports and a back end file with the linked tables (for network speed). I am not overly concerned about running regular compact/repairs on the front end, however I want to implement a solution to regularly compact and repair the backend tables.
I would like to put in some solution that allows the user to simply click a button on the switchboard that will perform the compact on the linked tables file, at their discression. However, I can't determine how to set this up....and know it is working and will work in a multi user environment.
The only other option I can see is to enable compact on close for the backend file. However, I am not certain how this would react in a multi user network environment.
Any suggestions?
Hammy