Limit Users

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

louciv - 07 Dec 2007 20:37 GMT

I have a Microsoft Access front end connected to a Microsoft Access backend.
The back end is on a network share. I would like to be able to limit the
number of users that can connect to the back end to a certain number. How
can I limit the number of users to my backend database?

Thanks in advance,
Lou

Reply to this Message

Tom van Stiphout - 09 Dec 2007 01:33 GMT

There is no built-in way to do that. What comes to mind is to check
the LDB file using that DLL - what's its name? - that MSFT has
available for that.
Otherwise roll your own: at startup time increment a counter in some
table the BE, and if greater than X, DoCmd.Quit. If you go down this
road, you must think about how to handle crashes, where the client
doesn't have a chance to decrement the counter at closedown time.

-Tom.

>I have a Microsoft Access front end connected to a Microsoft Access backend.
>The back end is on a network share. I would like to be able to limit the
[quoted text clipped - 3 lines]
>Thanks in advance,
>Lou

Reply to this Message