Problem: database open as Read-only Mode

C

Clement

Hi,

I have just develop an application using access for my client, the app. is
in single use mode and very user would have a copy installed in their
machines. However, some users report that the file is opened as read only and
can update any records in the database, this problem only happens on some
machines. I believe that should be due to the local access configuration.
Have anybody encounter such problem before, if so, how did you fix it?

Thanks
 
N

Nick Coe \(UK\)

Use Windows Explorer to examine the properties of the
application mdb file on each of the problem machines. Check
that the 'Read Only' property check box is clear.

Some versions of Windows leave the 'Read Only' set when
copying from a CD.

If that is clear and if it still does not work then it may
be a problem with user permissions for the directory/folder
and or file. You need an administrator for that machine to
set the user account rights appropriately.

You do not say in your post whether your application and
data are combined in the same mdb. In any case, set
Tools|Options|Advanced to 'shared' even if you only have one
user at a time using the application it can't do any harm.

If your application is split into the classic Front End/Back
End configuration then you must make sure that all the
foregoing are applied to both files.
 
Top