Resolving Security Issues

[Guest]

While working with the test version of my program, I unknowingly screwed up a
few things. Earlier I could no longer right-click on tables, querys, forms,
etc. to add a description and now I cannot even open the program because
"Security settings restrict access to the file because it is not digitally
signed."

How do I reverse these settings so I can get back to work trying to improve
the efficiency of the food bank. Thanks in advance for your help.

 

[Guest]

Hi, Earl.

How do I reverse these settings so I can get back to work

Open Microsoft Access 2003 itself (without opening a database), then select
the Tools -> Macro -> Security... menu to open the Security dialog window.
Select "Low" and then select the "OK" button to save your change. Close
Access.

Now try to open your database and see whether you are still restricted on
making your changes to the objects. If so, check whether the database file
was opened in read-only mode, either by virtue of the Windows file attributes
setting, Windows security setting, or by a command-line switch used to open
the database file. If you still have problems, please post back.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.

 

[Guest]

Your suggestion fixed the restrictions on opening the database, but did not
fix the ability to right-click on objects. I am not sure how to determine
whether is was opened in read-only mode, whether there was a command line
switch or a Windows setting causing the problem. I think I changed an Access
setting that disabled the right-click capability because it occurred after I
was experimenting with things at Tools > Options. I still need help
understanding what I did to myself. I understand mainframe and C programming
but I am a newby to VBA and the more involved portions of VB6. I am
self-teaching from a book. 57 Chevy Nomad at home.

 

[Larry Daugherty]

A. Get a copy of your last good backup and start over in your
development area.

B. Recall each and every thing you changed and what you changed it
from and change it back.

The only reliable way is Option A above. When developing an Access
application, I backup and compress to a separate folder, then restore
to the current folder every time I exit the application. Unless I
know that the current version is corrupt in some way. In that case I
inhibit the backup and get a copy of the last backup to continue
development.

HTH

 

['69 Camaro]

Hi, Earl.

I think I changed an Access
setting that disabled the right-click capability because it occurred after
I
was experimenting with things at Tools > Options.

Select the Tools -> Startup... menu to open the Startup dialog window.
Ensure that the "Allow Default Shortcut menus" checkbox is checked. If you
change this setting, then select the "OK" button to close the dialog window,
then close Access. Open the database again and your new setting will take
effect.

I am not sure how to determine
whether is was opened in read-only mode, whether there was a command line
switch or a Windows setting causing the problem.

I think fixing your default shortcut menus will solve the problem, but I can
explain the other mysteries about opening read-only databases for you. With
a command-line switch to open the file in read-only mode, a Windows
shortcut, or the command line (Start -> Run), or a VBA procedure using the
Shell command would be used to open the database. The read-only
command-line switch is /ro and the complete command would look like the
following:

"C:\Program Files\Microsoft\Office03\OFFICE11\MSACCESS.EXE"
"C:\Work\MyDB.mdb" /ro

If it's a Windows file attribute that makes the file read-only, then open
Windows Explorer and navigate to the file. Right-click and select
"Properties" on the pop-up menu to open the Properties dialog window. If
the Read-only Attribute check box should be unchecked.

If it's a Windows security setting that makes the file read-only, then
select the Security tab and check your security settings on the Properties
dialog window. If only "Read" is selected for your user name, then you
won't have any other permissions, such as modify or write, which is what you
need to make changes to the database file.

I understand mainframe and C programming
but I am a newby to VBA and the more involved portions of VB6.

Then you will find many new ways to shoot yourself in the foot. ;-) For an
amusing perspective on VB programming from a C programmer's point of view,
please see the following Web page for a link to Verity Stob's article,
"Thirteen Ways To Loathe VB":

http://www.Access.QBuilt.com/html/articles.html

57 Chevy Nomad at home.

Cool!

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.