@simon: "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 "
    @ltrappNoSpam: "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?
Lynn Trapp
MS Access MVP
<url>
Access Security: <url>
"Simon Webb" <email_address> wrote in message 
news:ctv7f1$mgu$<email_address>
<quote>"
    @simon: "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
news:MGLMd.974$<email_address>
<quote>"
    @simon: "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" <email_address> wrote in message 
news:<email_address>
<quote>"
    @ltrappNoSpam: "<quote>
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.
Lynn Trapp
MS Access MVP
<url>
Access Security: <url>"
{'source': 'USENET', 'other_information': '{"reply_count": 4, "forum_name": "microsoft.public.access.gettingstarted.20140624.mbox"}', 'file': 'data/output/usenet-microsoft.public.parquet'}