ms access 2016 command line

COACHMAN99
COACHMAN99 used Ask the Experts™
on
Hi Folks
Using the /ro switch on a command-line:
Does anyone know how to hide/disable the yellow 'read only / save-as' notification bar?
thank you
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Remote Training and Programming
Top Expert 2015
Commented:
File, Options, Trust Center, Trust Center Settings... command button, Message Bar -- Never show information about blocked content

Author

Commented:
Thanks Crystal
(Access 2016 doesn't have the above menu options (I go via 'what do you want to do' / options))
Either ways, we definitely don't wish to switch off blocked-content warnings, just the 'save-as' bar.
The issue isn't related to blocked content, it is triggered by the read-only parameter in the command-line, and remains unless the user saves as a different file (not valid).
If the /ro is omitted from the command-line them there are no messages.
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and Programming
Top Expert 2015

Commented:
try opening the database using a shortcut icon as opposed to opening it directly
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
tried that - same problem - (I'm sure this worked in previous versions of Access)
even if I agree to the 'save-as', and make a new file, every time I use the command-line with '/ro' on the new file, the 'save-as' prompt returns.
thanks
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and Programming
Top Expert 2015

Commented:
what is the purpose of the hidden database?
Most Valuable Expert 2015
Distinguished Expert 2018
Commented:
Couldn't you use the runtime switch:

    /runtime

/gustav

Author

Commented:
Crystal and Gustav. I was looking for a quick way to stop people editing data. Was hoping the /r would facilitate this. Instead it stops people editing the actual design of the fe.
Not sure if the /runtime will be any different to /r.
Will close question. Thanks.
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and Programming
Top Expert 2015

Commented:
you're welcome

> "stop people editing data"
that has to actually be implemented in the code for the forms in the user interface.  Most folks do not open tables directly if there is a menu interface -- especially if you mark the tables as hidden (right-click)

Author

Commented:
Thanks.  One can also set form insert/edit/update properties to false instead of coding a solution
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and Programming
Top Expert 2015

Commented:
you're welcome
yes, that is true. If you set the Recordset Type on the Data tab of properties for the form is set to Snapshot, users will not be able to edit. The reason I mentioned code is because usually the same forms are used for those who can do data entry as for those who are read-only.

Generally, you do NOT want to make a form not able to be edited because this will affect the ability to edit any control, including unbound controls that are used to find records.  Better is to lock individual controls programmatically -- using code to determine privileges of the user and then looping through controls and setting the Locked property  to True (Yes) or False (No).

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial