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]
