First user allow to read and write, 2nd user only allow to read

[mavisyew]

Hi All,

Will like to check, i have a access database which can be open up by a few users.
How can i only allow the first user who open up the database to read and write the database and the follow users who open up the access have only read access?



Thanks

[orange]

Can you tell readers a bit more of the application? I've seen databases where an Admin account is allowed R/W to a reference database; but the general user has readOnly.
This is controlled via Login parameters.

[mavisyew]

Hi,

The database is for user to log case.
Only one user is allow to log case.
The other user when open the database they can run report.

Two users tried to open the database at the same time but neither one of the user can make changes to the database.

[orange]

Only 1 user can make changes OR
Only the first user to login???????????????

[mavisyew]

Either will do.
Which one Easlier to archive?