Avatar of Neil Randall
Neil Randall
Flag for United Kingdom of Great Britain and Northern Ireland asked on

READ ONLY message displayed when opening an Accde database

I have designed a database application for use by several users on the network. The Access application is a client/server application with an Accde front end and Access runtime libraries installed on each user's computer. Thus not requiring a full copy of Microsoft Access.
The back end linked table database is located on a network share in a folder that all users have [Modify] permissions but not [Full Control].
The client front end file is run from C:\Program Files (x86)\Microsoft Office\Office16\ACCWIZ folder because it is a Default trusted location within Access and this location stops the security messages popping up when a user first opens the application.

However.

When the front end application is run the opening form has the following message displayed across the top:

"READ ONLY. This database has been opened read only. you can only change data in linked tables. To make design changes, save a copy of the database"
An a [Save As] button.
This would be confusing for the users.
How can I hide the message?

Thanks for your time

Neil
DatabasesMicrosoft AccessNetworking

Avatar of undefined
Last Comment
Neil Randall

8/22/2022 - Mon
SOLUTION
ste5an

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER CERTIFIED SOLUTION
Scott McDaniel (EE MVE )

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Jim Dettman (EE MVE)

User must have Read/Write/Create/Destroy permissions on the Folder. I'm not sure if Modify permissions provide that (probably does, but ask to be sure).

 Note that this is for the front end as well as the back end.  Right now, you're getting that "read only" message as a result of the permissions on the front end directory.

Jim.
Scott McDaniel (EE MVE )

Note that this is for the front end as well as the back end.
Right, and the same goes for the Trusted Location issue. You must add both as a Trusted Location, if both machines are setup to require that.
Gustav Brock

Always use a folder of the user to hold your frontend which - to Windows - is a document.

You can run a script to simplify the full process of deployment and updating the frontend. I explained it here:

Deploy and update a Microsoft Access application in a Citrix environment
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Neil Randall

ASKER
Thanks to you all.

Ste5an for getting me started with the Reg changes
Scott for breaking it down and explaining it very simply
Jim and Gustav for reminding me to focus on the user and permissions