Hi
I have an access database which is shared with 10-15 users. On a daily basis, I update the access database with excel data which changes everyday and then update the access database. I use VBA macro in excel to do that by updating the table in access i.e open connection to access, update/add new records in this access.
However when i update/add the access there might be a couple of people using it(they have the windows access Form open] and i get an error. I can only update if no-one is using the database. what should i do? i works fine if noone have the access form open on their computer. i cant call them everyday to close it before my update.
how to close the application[shut down the access form] of the other users before my update? if yes how to do it in VBA excel?
I have an access database which is shared with 10-15 users. On a daily basis, I update the access database with excel data which changes everyday and then update the access database. I use VBA macro in excel to do that by updating the table in access i.e open connection to access, update/add new records in this access.
However when i update/add the access there might be a couple of people using it(they have the windows access Form open] and i get an error. I can only update if no-one is using the database. what should i do? i works fine if noone have the access form open on their computer. i cant call them everyday to close it before my update.
how to close the application[shut down the access form] of the other users before my update? if yes how to do it in VBA excel?
Last edited:
