Help Locked out of my own database

  • Thread starter Thread starter paul
  • Start date Start date
P

paul

Hi,

in an attempt to secure my database, i deselected a number
of options under Tools : Startup. Now when i try to get
access to my tables and other stuff i cant...i thought
there was some short key that would bring them back up...
 
Hi, Paul.

While opening the database file, hold the <SHIFT> key down until the
database is completely open. The built-in menu and toolbar should be
displayed so that you can adjust the startup settings again. If you don't
see the database window after the database is open, press <F11>.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
thanks for the tip, i can get access to the database
window using the F11 key

I still cant get access to the tool bar to adjust the
startup setting, any other thoughts...

i tried to hold down the shift key but i had already
enabled the password on open facility in access...

any thoughts on how i can get to the start up setting and
turn them off....

Paul
 
Hi, Paul.
i tried to hold down the shift key but i had already
enabled the password on open facility in access...
Click to expand...

Hold down the <SHIFT> key while clicking on the "OK" button after entering
the password, and continue holding the <SHIFT> key until the database is
fully open.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
Gunny,

thank you its working. i noticed that if i open the
appliation access first of all and then open the database
from access the shift key thing works...

thank you for your assistance.

This now leads to my next question. how do i change that
SHIFT Key thing to a different key as i assume that anyone
who knows a bit about access can get in still....


Paul
 
Hi, Paul.

You're welcome.
how do i change that
SHIFT Key thing to a different key as i assume that anyone
who knows a bit about access can get in still....
Click to expand...

Correct. Many people know about the <SHIFT> key to bypass the startup
options. One can disable the <SHIFT> key bypass by setting the
AllowBypassKey Database Property to FALSE. The procedure for doing this is
on this Web page:

http://support.microsoft.com/default.aspx?id=826765

Which leads to your next question: How do I prevent people from using this
same method to turn the setting for the AllowBypassKey Database Property to
TRUE? Some people are bound to know this trick, too.

The code for that is listed on this Web page:

http://www.mvps.org/access/general/gen0040.htm

Which leads to your next question: How do I prevent people from using this
same technique to delete the AllowBypassKey Database Property, thereby
re-enabling the <SHIFT> key bypass? Some people are bound to know or find
this trick, too.

The answer lies in the fact that everyone logs into the default workgroup as
the "Admin" user, who is a member of the "Admins" group, which has the
security permissions to make this change. If one applies user-level
security to the database, then the default "Admin" user isn't a member of
the Admins group, so can't make this change when granted the least amount of
permissions and can't even open the database when not granted any
permissions.

Which leads to your next question: Is there a way around this security,
too?

Yes. All one can do is set up ever higher hurdles to prevent most people
from getting into the database. Access is not secure, so don't store data
in it that must be safeguarded against those with more than a reasonable
amount of curiosity.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
thanks again for your help,

ive posted another question about passwords in code. i
dont think ive explained my self particularly well.

ive written some code that contains a password, ideally i
want to look up the password in a table is it possilbe...

Paul
 
Hi, Paul.

I see that Ron Weiner has already answered your other post with a suggestion
to use the DLookup( ) function to retrieve the password from a table. The
only argument I have is that passwords shouldn't be saved in tables -- for
security reasons. Anyone who can open the database and has permission to
"Read Data" in the table can read the passwords.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
Back
Top