I disabled the security to my database and I can't log onto it now

[Guest]

I just completed a time consuming database and set up security on it.
I joined the workgroup and a logon screen appeared to login giving me
exclusive rights.
I then disabled the login screen by clearing the password out as directed in
Help file to stop the login screen. However now I cannot make changes to the
database!
I tried rejoining the workgroup and I still can't get a log in screen now.
Does anyone know how I can log into the database as my old username I was
using so I could make changes.
I even tried creating a new database and importing all objects and I
couldn't import all of them (forms and macros)...

 

[Rick Brandt]

I just completed a time consuming database and set up security on it.
I joined the workgroup and a logon screen appeared to login giving me
exclusive rights.
I then disabled the login screen by clearing the password out as
directed in Help file to stop the login screen. However now I cannot
make changes to the database!
I tried rejoining the workgroup and I still can't get a log in screen
now. Does anyone know how I can log into the database as my old
username I was using so I could make changes.
I even tried creating a new database and importing all objects and I
couldn't import all of them (forms and macros)...

As soon as the default user "Admin" has his password removed then you are no
longer prompted. Open the file and reapply a password to the Admin user or
open the file with a shortcut like...

"Path to MSAccess.exe" /wrkgrp "Path to MDW" "Path to MDB" /User
YourUserName

The final argument above should cause a login prompt where you can provide
your password.

 

[Guest]

Thanks Rick.. I just hope the default Admin user has the rights to enable
the password. Otherwise could I run that shortcut from run?

 

[Rick Brandt]

Thanks Rick.. I just hope the default Admin user has the rights to
enable the password. Otherwise could I run that shortcut from run?

Since it is "his" password I believe he should. The question is whether the
app exposes any menus for him to get to the area where he can change the
password.

 

[Guest]

Problem is, was logged on as timt, now I automatically log on as admin....
admin does not have the rights. I need to log on as timt again and thats
where the problem is.

 

[Guest]

Rick,
I've been trying to use that path you recommended but I don't think I'm
typing the syntex correctly
"c:\documents.....\msaccess.exe"\"i:\epinternational\general\security.mdw"\teskt
is that correct? the security file is on the network...

 

[Rick Brandt]

Problem is, was logged on as timt, now I automatically log on as
admin.... admin does not have the rights. I need to log on as timt
again and thats where the problem is.

Again I would think a user always has rights to change his own password. If
that's not true then I don;t understand the logic behind it. The shortcut
method I posted earlier should allow you to login as any valid user even if
Admin doesn't have a password.

 

[Joan Wild]

Rick,
I've been trying to use that path you recommended but I don't think
I'm typing the syntex correctly.
"c:\documents.....\msaccess.exe"\"i:\epinternational\general\security.mdw"\teskt
is that correct? the security file is on the network...

That isn't correct, no. You are missing spaces and quotes.
"C:\Program Files\Microsoft Office\Office\msaccess.exe" /wrkgrp
"I:\epinternational\general\security.mdw"

Verify the path to msaccess.exe on your machine - it likely is different
than the above.

Then create a new mdb. You'll be logged in as Admin, but that's OK. Go to
Tools, Security, Accounts. Click on the Change Password tab and set a
password for Admin (since you are logged in as that user)

Close the database and Access. Change the target in the above shortcut to
include the full path to your secure mdb.
"C:\Program Files\Microsoft Office\Office\msaccess.exe" "path to securemdb"
/wrkgrp "I:\epinternational\general\security.mdw"