?
Solved

ms access 2016 command line

Posted on 2016-09-01
10
Medium Priority
?
126 Views
Last Modified: 2016-09-02
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
0
Comment
Question by:COACHMAN99
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
10 Comments
 
LVL 21

Accepted Solution

by:
crystal (strive4peace) - Microsoft MVP, Access earned 1600 total points
ID: 41780325
File, Options, Trust Center, Trust Center Settings... command button, Message Bar -- Never show information about blocked content
0
 
LVL 7

Author Comment

by:COACHMAN99
ID: 41780473
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.
0
 
LVL 21
ID: 41780590
try opening the database using a shortcut icon as opposed to opening it directly
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 7

Author Comment

by:COACHMAN99
ID: 41780638
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
0
 
LVL 21
ID: 41780703
what is the purpose of the hidden database?
0
 
LVL 51

Assisted Solution

by:Gustav Brock
Gustav Brock earned 400 total points
ID: 41781434
Couldn't you use the runtime switch:

    /runtime

/gustav
0
 
LVL 7

Author Comment

by:COACHMAN99
ID: 41782178
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.
0
 
LVL 21
ID: 41782445
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)
0
 
LVL 7

Author Comment

by:COACHMAN99
ID: 41782480
Thanks.  One can also set form insert/edit/update properties to false instead of coding a solution
0
 
LVL 21
ID: 41782483
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).
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question