Link to home
Start Free TrialLog in
Avatar of Neil Randall
Neil RandallFlag 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
SOLUTION
Avatar of ste5an
ste5an
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
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.
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
Avatar of 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