Is this possible? If database already in use, limit all new users to read-only.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ben Smith - 10 Sep 2003 18:58 GMT

Is it possible to determine when a user opens a mdb to determine if other
users are currently using the mdb and if they are only allow the current
user to read-only access?

I'd like to do all of this through VBA code if possible.

Thanks.

Ben

Reply to this Message

Alick [MSFT] - 11 Sep 2003 10:06 GMT

Hi Ben,

Partly possible, you can refer to the code in the article to list the
current users logged into the database:

HOW TO: Check Who Logged into Database with Jet UserRoster in Access 2000
http://support.microsoft.com/?id=198755

However, it seems it is not possible to change the current user to
"read-only", any user will have the explicit creating objects permission by
default. For more about the security questions, please read the security
FAQ:

ACC2000: Microsoft Access Security FAQ Available in Download Center
http://support.microsoft.com/?id=207793

Please feel free to reply to the threads if you have any concerns or
questions.

Sincerely,

Alick Ye, MCSD
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

--------------------

| From: "Ben Smith" <ben.smith@mindspring.com>
| Subject: Is this possible? If database already in use, limit all new

users to read-only.

| Date: Wed, 10 Sep 2003 13:58:14 -0400
| X-Tomcat-NG: microsoft.public.access.multiuser
[quoted text clipped - 8 lines]
|
| Ben

Reply to this Message

HSalim - 12 Sep 2003 01:43 GMT

You can use command-line switches to start access in Read-only mode or
Exclusive mode but I am not sure you can have both - Exclusive and
read-only.

HS

> Hi Ben,
>
[quoted text clipped - 39 lines]
> |
> | Ben

Reply to this Message