force logon window

[ernie]

Hello,

I have a serious problem with my database. I remove the user name "admin"
from the usergroup "admins". I remove all permissions from the user admin to
open the database. I cleared the password for the user admin in error, so
when i close the database i dont get the option to enter the user name and
password to logon. i suspect the user admin is loging on by default. Now the
database dont open because the admin user dont have the permission to open
the database. I get the error message "You do not have the necessary
permissions to use the "db.mdb" object. Have your system administrator or the
person who created this object establish the appropriate permissions for you."

Is there anyway i can get pass this error message? Is there anyway to fix
this? How can i force the database logon window?

 

[Albert D. Kallal]

I did this once also.....

Do you have another id you can use to logon with?

The way I fixed this was I created a new shortcut, and *SPECIFIED* the user
logon name in the shortcut...

In fact, for development purposes, because a good number of different
databases for clients of mine, I ways create a shortcut in that directory
with a username/password so I don't every have to type that stuff in, or
even see a logon screen....

The shortcut will looking something like:

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
"c:\program files\RidesXP\RidesXP.mdb"
/wrkgrp "c:\Program Files\RidesXP\Rides.mdw"
/User "RidesAdmin" /pwd "password"

The above shortcut is broken where each space is, but it would be on one
line....

So, build a shortcut, and you can then specify the user + password, even if
your data base is not prompting you for a logon

 

[ernie]

Hello Albert,

Thanks for your reply. it worked like a charm.