Read Only Message

[John Lee]

I am planning on splitting my database for multiple users. however I've been conducting some testing on each workstation individually to make sure that they can access the database and view the parts of the database they've been set up for. The problem I have is that 3 out of 7 of my users are getting a READ ONLY message on opening up the database, the message reads as follows:

READ-ONLY This database has been opened read-only. You can only change date in linked tables. To make design changes, save a copy of the database.

The database sits on a cloud network, as this is how the company is set up. I noted that all of the folders in the various directories are all set up as Read Only, but I am able to open up the database and make any design changes I want and update the information in all of the tables, queries, forms and reports.

The other for users don't get this message and are able to use the database as intended without getting this READ-ONLY message.

Does anyone have any ideas of what may be causing this error message to generate and have any ideas how I can address it.

As it stands I can't progress to splitting the database if those end users are going to be getting this message each time they open the database as I don't want them to be make copies of the database.

Any assistance would be most appreciated.

 

[Gasman]

Before it was only one?

Unable to add record because of read only access

good morning folks, I have the following code written on my front end form in the on load event and for some reason when a particular user opens up the database an error message appears saying read only access, and the Rs.AddNew is highlighted, but it doesn't happen for any of my other users...

www.access-programmers.co.uk

 

[LarryE]

Each user must have their own FE version on their own computer that is then linked to the BE. Further, each user must have their copy in a Trusted Location on their computer.

 

[moke123]

The database sits on a cloud network, as this is how the company is set up.

I think we need more info on where the backend resides.

 

[GPGeorge]

@moke123 beat me to it. "Cloud" raises ugly questions about where this back end is actually deployed.

 

[The_Doc_Man]

The symptom of making a DB READ-ONLY also suggests permission issues, which might or might not be related to the precise meaning of "cloud" in this context. When Access cannot use an existing .LACCDB file, it has no choice but to open the corresponding DB locked to READ-ONLY.

 

[Gasman]

We had someone else recently calling their company network 'the cloud', so clarification is needed, as usual.