General discussion

Locked

Access 97 Can't Update, Read Only Error

By giant45man ·
The company I work for is moving from a Novell domain to a Win2K domain. I copied a database named "sales" from the Novell file server to the Win2K file server. I gave our users access to the file. When the users open Access and browse to sales folder it opens fine. The problem arises when they try to generate a report in Access, it gives the following error:
"Can't update. Database or object is read-only"

I checked User and Group Permissions and the settings are identical to the way the settings are for the users who are still on the Novell domain. The users on the Novell domain have no problem generating the report. I have a feeling the it has something to do with the Design Master still being on the Novell domain that is causing this, but I am not sure. Any suggestions?

This conversation is currently closed to new comments.

10 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Access 97 Can't Update, Read Only Error

by DKlippert In reply to Access 97 Can't Update, R ...

I believe you need Read/Write/Create/Modify permission with Win2K

Collapse -

Access 97 Can't Update, Read Only Error

by giant45man In reply to Access 97 Can't Update, R ...

Poster rated this answer

Collapse -

Access 97 Can't Update, Read Only Error

by giant45man In reply to Access 97 Can't Update, R ...

Where would I set these permissions?

Collapse -

Access 97 Can't Update, Read Only Error

by danny.huynh In reply to Access 97 Can't Update, R ...

What is the database structure? You might have a Front-End/Back-End database, and the back-end might still be on the Novell server?

Collapse -

Access 97 Can't Update, Read Only Error

by giant45man In reply to Access 97 Can't Update, R ...

Poster rated this answer

Collapse -

Access 97 Can't Update, Read Only Error

by Gary_W In reply to Access 97 Can't Update, R ...

I had a similar problem once. Make sure to delete the .ldb files. These contain the locks from previous users.

I had to re-install access on my machine once before the problem would go away.

Good luck,

Gary

Collapse -

Access 97 Can't Update, Read Only Error

by giant45man In reply to Access 97 Can't Update, R ...

Poster rated this answer

Collapse -

Access 97 Can't Update, Read Only Error

by lorenzoy2000 In reply to Access 97 Can't Update, R ...

How is your network enviroment?Are you managing security via NWADMIN for both platforms or what?

Collapse -

Access 97 Can't Update, Read Only Error

by giant45man In reply to Access 97 Can't Update, R ...

Poster rated this answer

Collapse -

Access 97 Can't Update, Read Only Error

by giant45man In reply to Access 97 Can't Update, R ...

This question was closed by the author

Back to Windows Forum
10 total posts (Page 1 of 1)  

Related Discussions

Related Forums