Prevent more than one user/IP in adding/editing information in VPN

[adi2011]

Hello,

I have just setup Access database on VPN so it could be shared in VPN (using Hamachi) between to
different geographic locations. It is basically one user in database. My client wanted to access
program from two different sale places.
This is what I don't know how to solve: I would like to disable loging one user from two different
locations at the same time. This way I would prevent user from entering database at the same time.
So when user tries to login at same time from two different locations, program should show message
like "Unable to access. Other user is using apllication, please try latter."

Any help is appreciated and many thanks in advance for prompt reply.

Cheers,
Adi

 

[vbaInet]

I don't know your setup but you can create a table to hold the logged in status of each user. So when the db opens and the user has been authenticated, you update the table and when the db closes update the table again.

Then you need to give rights to the Administrator to be able to "unlock" the user.

 

[gemma-the-husky]

the other issue is how access to the dbs is controlled, which depends what happens after they connect via the vpn.

 

[adi2011]

Thank you very much for your help, I found the solution and it's working great

For anyone who will have the same problem, here is the link that helped me solve part of my problem:

http://www.databasedev.co.uk/login.html

All the best,
Adi