How to tell whose using the database

[Emma]

Hi I have a networked database now I need to be able to see who the users are
that are online because I only want to do updates when all the users are
offline. Is this possible I'm using 2007.
Thanks Emma

 

[Douglas J. Steele]

Check http://support.microsoft.com/kb/198755/EN-US/

If your database is in the old MDB file format, you'd still use a connection
string like in that article. If it's in the new ACCDB file format, you'd use
something like

cn2.Open "Provider=Microsoft.ACE.OLEDB.12.0;" _
& "Data Source=C:\myFolder\myAccess2007file.accdb;" _
& "Persist Security Info=False;"

Hopefully you do know that your database should be split into a front-end
(containing the queries, forms, reports, macros and modules), linked to a
back-end. Only the back-end should be on the server: each user should have
his/her own copy of the front-end, ideally on his/her hard drive.

 

[Emma]

Hi Douglas,

I haven't had a chance to try what you said yet. As I'm using an ACCDB file
it appears as though there is a user in the database because the ACCDE file
shows up but the second security file doesn't. I'm a little confused about
which files should be in the directory? Can you help?

Thanks Emma

 

[Douglas J. Steele]

The ACCDE file is simply a compiled ACCDB.

Your application should be split into a front-end (containing the queries,
forms, reports, macros and modules), linked to a back-end (containing the
tables and relations). The front-end can be either an ACCDB or an ACCDE. The
back-end should be an ACCDB (there's no benefit in converting a tables-only
database to an ACCDE). Only the back-end should be on the server: each user
should have his/her own copy of the front-end, preferably on his/her hard
drive. Set up like that, you'd only care about whether someone's in the
back-end. And realistically, if there's no LACCDB locking file, that
generally indicates no one's using the application (unless they opened it
exclusively as read-only)