Read Only error

A

Antavas

I have created a database that is supposed to be used by mulitple people in
my department. To avoid issues with having people locked out of it I had them
make a copy of the file stored in the network drive and pasted a copy to
their desktop. When I tested it everything I did with my desktop copy shared
into the one stored in the network.

The issue is that everyone else who trys to use it gets an error that states
that "Cannot update. Database or object is read-only"

I'm guessing there is a permissions issue somewhere but I'm not sure how to
resolve it. I need it so anyone with a copy can add and modify records.

Any help would be greatly appreciated.
 
J

Jeff Boyce

If part of what they need is stored on the network, they'll need permissions
to read-write to that part of the network (including the folder it's in).

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
A

Antavas

They have full access to the network drive and the folder its stored in. In
fact when we tried to have just one of them modify a record in the network
copy they got the same Read Only error.
 
J

Jeff Boyce

The only time I've seen that happen is when the folder holding the
back-end/data file does NOT have "write" permission. Perhaps someone else
here can offer other resolutions...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
A

Antavas

The database tables are shared lists from SharePoint. Could this be what is
causing the permission issue?
 
H

Hans Up

Antavas said:
The database tables are shared lists from SharePoint. Could this be what is
causing the permission issue?

Check your user's permissions on the lists in SharePoint. Do they have
read-only permission? Or do they have edit permission like you?
 
S

Scott H

I found out that by copying the .mdb file over the network caused the attribs to corrupt. So, I zipped the .mdb first and containing folders, then unzipped on the destination pc. Read Only error went away.





Antavas wrote:

Re: Read Only error
31-Aug-09

The database tables are shared lists from SharePoint. Could this be what is
causing the permission issue

:

EggHeadCafe - Software Developer Portal of Choice
How To Create a Custom IE8 Accelerator
http://www.eggheadcafe.com/tutorial...a-11c3e7cc2a61/how-to-create-a-custom-ie.aspx
 

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