I am fairly new to Access. I have split my database because we have multiple users. Only two users can edit data and the rest can just displaythe data. I want the "edit users" to be able to Compact/Repair the database. To allow this, I have created local tables on the front-end and delete/insert data from the back-end database to the local tables on the front-end. This way the "display users" do not have a lock on the back-end database.
I have read that deleting/inserting data into a table will cause database bloat. They recommend creating a separate local database that will be deleted and created each time.
I do not understand how to do this. Do I have to use VBA code to recreate the local tables in the temporary database? I have searched for examples on how to do this but I could not find any.
Can someone please give me some code example for me to get started?
Thanks.
Sandy
I have read that deleting/inserting data into a table will cause database bloat. They recommend creating a separate local database that will be deleted and created each time.
I do not understand how to do this. Do I have to use VBA code to recreate the local tables in the temporary database? I have searched for examples on how to do this but I could not find any.
Can someone please give me some code example for me to get started?
Thanks.
Sandy