Solved

ms access 2016 command line

Posted on 2016-09-01
10
37 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
  • 5
  • 4
10 Comments
 
LVL 18

Accepted Solution

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

Author Comment

by:COACHMAN99
Comment Utility
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 18
Comment Utility
try opening the database using a shortcut icon as opposed to opening it directly
0
 
LVL 7

Author Comment

by:COACHMAN99
Comment Utility
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 18
Comment Utility
what is the purpose of the hidden database?
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 49

Assisted Solution

by:Gustav Brock
Gustav Brock earned 100 total points
Comment Utility
Couldn't you use the runtime switch:

    /runtime

/gustav
0
 
LVL 7

Author Comment

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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now