Locking a Database

[mattc66 via AccessMonster.com]

I have a database that is on our network. I would like to set it up to only
allow one user at a time into the database. What is the best way to do that?

Thanks
Matt

 

[ruralguy via AccessMonster.com]

You could check for the existance of the .ldb file on the BackEnd and exit.
Access can handle multiple users updating the BackEnd at the same time so why
restrict the system?

 

[mattc66 via AccessMonster.com]

This database downloads data from an external ERP system. If 2 users do the
download at the same time the download gets messed up.

 

[ruralguy via AccessMonster.com]

Understood. Couldn't you set up a table that would signal that the download
is in progress and disable the download for anyone else instead of making a
single user system?

This database downloads data from an external ERP system. If 2 users do the
download at the same time the download gets messed up.

You could check for the existance of the .ldb file on the BackEnd and exit.
Access can handle multiple users updating the BackEnd at the same time so why

[quoted text clipped - 5 lines]

 

[mattc66 via AccessMonster.com]

That sounds like a good idea. How would I set that up?

Understood. Couldn't you set up a table that would signal that the download
is in progress and disable the download for anyone else instead of making a
single user system?

This database downloads data from an external ERP system. If 2 users do the
download at the same time the download gets messed up.

[quoted text clipped - 4 lines]

 

[ruralguy via AccessMonster.com]

I have a tblSystem that I open and it contains flags like this or other
fields that I might need for the system. One field is the number of seconds
before the system shuts down so I can kick others out of the system for
maintenance. I have a hidden form whos timer event checks every 10 seconds
to see of the value is non zero. My SystemTable only has one record but it
is very handy.

That sounds like a good idea. How would I set that up?

Understood. Couldn't you set up a table that would signal that the download
is in progress and disable the download for anyone else instead of making a

[quoted text clipped - 5 lines]