Search results

it works I commented out the delete and make links and it compresses. thanks for the help

will try I will try and not unlink and do the compress to see what happens, now that the switchboard has been moved to the FE DB thanks for the help

now working thanks for all the help. I figured out why the backend DB was open. The switchboard was located in the BE database. I moved it to the front end and now I can close the BE when I unlink all the tables.

I have a front end and back end database I have broken the links between the 2 databases how can I close the backend database using VB from code in the front end database? I keep getting errors that the DB is not exclusive

compression The modules create recods in temporary tables to do the analysis and then delete the data when done. The data is multi-dimensional and I create several entries determine the value and then store the summary and blow a way the detail. Since this is repeated for thousands of data...

I have a ms access database that I have split into a front and backend database. After the user enters data into the database (stored in the backend), the DB grows to about 50 MB. The user then runs the application (VB module stored in the front end DB) and the backend database grows to about...