Database is Read-Only for users without administrative rights

D

DavidUp

I have recently set up a multiuser database with a front end on each users
workstation and the back end on the server. All users are forced to use the
front end in Access 2007 Runtime mode.

The system has been tested for several weeks and worked fine in a branch
office where all users are at administrator level.

When I transferred the database to our head office I discovered that
standard users (i.e users, mobile users or power users) receive a warning
message that the database has been opened in read only mode.

Whilst these users are able to edit most of the data on the forms and
queries they are prevented from adding or editing hyperlinks which is
necessary to access clients' folders on the servers.

The strange thing is that this only happens when we force users to use their
locally stored front end. If a user finds their way to the master front end
stored on the server the database opens without any restrictions as to which
fields can be edited.

Needless to say for security and network traffic reasons we do not want all
users accessing the front end on the server.

Both servers are running under Server 2003 and all workstations are Windows
XP.

Has anyone got any ideas please?
 
K

Ken Snell \(MVP\)

Each user must have full rights (create/read/edit/delete) for the folder
where the backend file is located. Without these rights, the user's front
end file cannot create the .ldb file in that folder, and therefore the user
cannot edit/enter data in the front end.
 
D

DavidUp

Thanks Ken

That provided the answer with the proviso that I had to give the same rights
to the front end folder on the workstation; but then maybe that is something
I should have done anyway.

Thanks again you have saved several days development time being being
written off as an unworkable exercise.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top