Limit number of users

[Ian]

Using Access 97 I want to distribute my database over a LAN but limit the
number of PC's that can use it at the same time. Perhaps limit it to 3 so
when the 4th user tries to open it they cant until one of the others closes
the database. I have seen other application that do this according to the
number of users that are licensed for it.

I don't expect anyone to write the code for me but if anyone could point me
in the write direction it would be appreciated, I have no idea how to even
count the number of PC's that have the database open at any one time.

[Douglas J. Steele]

To be honest, I'm not sure it's possible. You could have each user write a
record to a table when they open the database, and delete it when they close
it, but there can be problems with that approach. You could also take a look
at http://support.microsoft.com/?id=186304 which explains how to read the
LDB file, but that's not 100% reliable either.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Ian" <ia********@ntlworld.com> wrote in message
news:3Z***************@newsfe1-gui.server.ntli.net...

Using Access 97 I want to distribute my database over a LAN but limit the
number of PC's that can use it at the same time. Perhaps limit it to 3 so
when the 4th user tries to open it they cant until one of the others closes the database. I have seen other application that do this according to the
number of users that are licensed for it.

I don't expect anyone to write the code for me but if anyone could point me in the write direction it would be appreciated, I have no idea how to even
count the number of PC's that have the database open at any one time.

[Salad]

Ian wrote:

Using Access 97 I want to distribute my database over a LAN but limit the
number of PC's that can use it at the same time. Perhaps limit it to 3 so
when the 4th user tries to open it they cant until one of the others closes
the database. I have seen other application that do this according to the
number of users that are licensed for it.

I don't expect anyone to write the code for me but if anyone could point me
in the write direction it would be appreciated, I have no idea how to even
count the number of PC's that have the database open at any one time.

Look for LDBView, or else MSLdbUsr.DLL, in google groups
(http://groups.google.com/advanced_group_search?hl=en) or at MS
Support....I'm sure google would be quicker.

You can get a return count on the number of people in the system.