Force Access to be only single user

[Simon Webb]

I am developing an application where I want to make sure it can only be run
on a single user basis. I will be splitting it FE / BE.

Is there a way I can make sure it can only be run on a single user basis. It
will be deployed in a situation where power cuts are guaranteed; so the
'lock' needs to be robust enough to cope with power cuts.

Ideally I want this property to be controlled and set in code.

Thanks in advace

Simon Webb

 

[Ed Robichaud]

Opening an mdb in "exclusive" mode will ensure a single user. Not sure why
you think that will solve your power supply problems, rather than buying a
UPC. Data file corruption is possible/probable whenever the plug is pulled
on an open file, regardless of the number of active users. Record locking,
which is set on the form's property, controls multiple user clashes much
more elegantly than limiting the mdb to one user.
-Ed

 

[Lynn Trapp]

Running Access in exclusive mode kind of defeats the purpose, but it can be
done. You can give your users a desktop shortcut to open the database with
the /excl switch. Use the following general syntax in your shortcut's
target.

"FullPathToMSAccess.exe" "FullPathToDatabase.mdb" /excl

What are you hoping to accomplish by allowing only one user at a time?

 

[Simon Webb]

Thank you for this.

What I meant to say was that my client is likely to have a powercut when
using the system. When power is restored I don't want him to find that he is
still locked out of the application.

- Simon

 

[Simon Webb]

Thank you for this


i) At the moment I don't have the resources to test it as a multi user
application. I don't want any one using it in multi user mode until I feel
secure.

ii) I want to market it as both a single user system with an upgrade path to
multi user at an additional cost.

regards

Simon Webb

 

[Lynn Trapp]

i) At the moment I don't have the resources to test it as a multi user

application. I don't want any one using it in multi user mode until I
feel secure.

Then just opening it in Exclusive mode is probably the easiest way to go.
You could also put it in a shared folder that no one else has access to.