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.

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" <ian.sexton@ntlworld.com> wrote in message
news:3ZqAc.646$lf4.480@newsfe1-gui.server.ntli.net...[color=blue]
> 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[/color]
closes[color=blue]
> 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[/color]
me[color=blue]
> 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.
>
>[/color]

Ian wrote:
[color=blue]
> 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.
>
>[/color]
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.