Code to determine if another user has the database open 1

[juddymarch]

Hi, done a few searches on google and on here but I can't find what I'm after. I'm just wondering if anyone knows if it is possible to determine if anyone else has the current database open. I want to quit out of the database if the user opens it but another user already has it open.

Thanks
Justin

 

[KenReay]

Hi

See

http://support.microsoft.com/kb/208778

Show help you you

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[jrbarnett]

Just force it to open exclusive. That way, if a second person tries to open it, they won't be able to.

Give them a shortcut that opens it exlusive, as per

http://support.microsoft.com/kb/209207

eg to open the Northwind database with Access 2002 (XP) exclusively:

"C:\Program Files\Microsoft Office\Office10\msaccess.exe" "C:\Program Files\Microsoft Office\Office10\Samples\northwind.mdb" /Excl

John

 

[MichaelRed]

just because I'd like to know ... why?

It is SUPPOSED to be a relational database, and should fully expect to be able to support multiple concurrent users ...



MichaelRed

 

[juddymarch]

Thanks for the replies, shortcut technique won't do it as the users may open it through explorer. I will have a look at your suggestion thanks KenReay.
The issue I have is that it is a database that is used in a large organisation, it is currently split with a front end under each users folder on terminal server. Occasionally users who know a bit too much tend to open the same frontend version from the same location (not their own folder).
This is currently not too much of an issue but it could become one as we are moving the backend to sql server and I have developed a couple of continuous forms that use temp tables stored in the frontend. I would prefer if users aren't accessing the same temp frontend table in the same database file. So it is basically a precaution i would like to have in place.

Thanks
Justin

 

[MichaelRed]

thanks, I like to understand these issues.




MichaelRed

 

[jrbarnett]

Can I suggest using network file system permissions on your servers so that people can only get to their own copy of the front end application? (with admins having rights to look at all for support purposes).
Your server admin people should be able to do this without much hassle.

John

 

[MichaelRed]

but she is saying that the same person opens multiple copies of the app using different techniques. i would assume that they would have to use the same log on, so the easy way to do it would be the open exclusive. of course, it would also be possible to simply maintain a log of current users a-la those routines which delve into the locking table ...




MichaelRed