How to remove password dialog?

  • Thread starter Thread starter Kimmy
  • Start date Start date
K

Kimmy

Hi,

I am new to Access. I tried to set security using security
Wizard, I was able to set up the way I want. However, I am
still in development mode, I want to deactiviate password
dialog box, I clean user users/groups using wizard, but I
could not get rid of password prompt. In addition, I
notice that my secutity setting for this DB is also
applied also to the othe Access DB on my machine which is
noit the way I want.

I simply do not want password at all for now.

Thanks in advance
 
Kimmy said:
Hi,

I am new to Access. I tried to set security using security
Wizard, I was able to set up the way I want. However, I am
still in development mode, I want to deactiviate password
dialog box,
Click to expand...

I suggest you create/modify your desktop shortcut to include the
username/password. Add the following to the existing target
/user "whatever" /pwd "yourpassword"
I clean user users/groups using wizard, but I
could not get rid of password prompt.
Click to expand...

Not advised, but you can stop the login prompt by clearing the password for
the Admin user.
In addition, I
notice that my secutity setting for this DB is also
applied also to the othe Access DB on my machine which is
noit the way I want.
Click to expand...

You are joined by default to your secure mdw. use the workgroup
administrator (Tools, Security) to join the standard system.mdw. Use your
desktop shortcut for your secure database. It will bypass the default
workgroup for that session.
 
Hi,

After cleaning Admin pw, I was able to get rid of pw
prompt. Thank you.

However, when I copy my mdb file to another machine, I
still not able to access my db from there directly (MEANS
double click mdb file), I got msg that I do not have
permission. But if I access thru a shortcut on the desktop
then it's OK. How could it happen?I did clean all user
group and Admin pw. Do I need to do something with
secured.mdw file?

Many thanks in advance. Kimmy
 
Kimmy said:
Hi,

After cleaning Admin pw, I was able to get rid of pw
prompt. Thank you.

However, when I copy my mdb file to another machine, I
still not able to access my db from there directly (MEANS
double click mdb file), I got msg that I do not have
permission. But if I access thru a shortcut on the desktop
then it's OK. How could it happen?I did clean all user
group and Admin pw. Do I need to do something with
secured.mdw file?
Click to expand...

As I said, that is not advised. Clearing the password does not remove the
security. When you implement security, you remove all permissions for the
Admin user. By opening the mdb via a double-click, you are opening it using
the standard system.mdw which silently logs you in as 'Admin'. Since your
database has no permissions for 'Admin', you can't get in. You should put
the password back on the Admin account, and use the desktop shortcut.
 
Thanks for your response
how can I get to the original state in which no pw prompt,
no secured.mdw, I'd like to have no security setting at
all, just like when I created a new Access db.
Thanks again for your help.
Kimmy
 
Kimmy said:
Thanks for your response
how can I get to the original state in which no pw prompt,
no secured.mdw, I'd like to have no security setting at
all, just like when I created a new Access db.
Thanks again for your help.
Kimmy
Click to expand...

As I recall, you used the security wizard to secure your database. If so,
and providing you didn't decline, the wizard would have kept an unsecured
copy of your mdb. You'll find it in the same folder as your mdb, but it
will have a bak extension. Backup your secure database first (in case this
doesn't work), and then rename the bak file to have a mdb extension. Open
Access and ensure you are joined to the standard system.mdw that ships with
Access (it's in the windows system folder). You can use Tools, Security,
Workgroup Administrator to check/join this workgroup. Close Access, and
then open that bak file you renamed. If you are back to normal, then you
can delete the 'secured' database, and the secured mdw.

If you don't find the bak file, then you can unsecure your database by
logging in (using the secured mdw file) as a user that's a member of the
Admins group. Assign full permissions to every object to the Users group.
Go to Tools, security, WA and ensure you are joined to system.mdw. Then
close Access. Re-open Access and create a new database (you should get no
login); import all objects from your database and compact. This new
database will be unsecured, and you are safe to delete your old one and the
secure mdw file.
 
Thanks again for your reply.
1) I have no more bakup file therefore, I cannot follow
your first method
2) I do not know how to "Go to Tools, security, WA and
ensure you are joined to system.mdw". Everytime, I go to
Wizard, I got message "... when you're both logon as Admin
User and db has been previously secured"
3) I go with the third solution which create new DB and
imports all objects to the new one. But all of my codes
(VB) were not imported !!! Do I have to copy and paste the
codes for each event of my forms?

The funny is when I copy my db and secured.mdw to
different machines, some of them I have to access thru a
shortcut, some of them I can access directly by double
click. It's driving me nuts.

Thank you for your time. It just because I am new with
Access. Kimmy.
 
Kimmy, why are you running the wizard?
You need to use the workgroup
administrator to join the correct
workgroup. If you are using 97 or 2000
then use Start, Run, wrkgadm.exe. If
you are using 2002 or 2003 then go to
Tools, Security, Workgroup
Administrator. Don't run the wizard.

--
Joan Wild
Microsoft Access MVP

"Kimmy"
<[email protected]>
wrote in message
 
Many thanks for your reply.

I have Office 2000, therefore, I did not know how to go to
WA from Tools menu.
It's working now. It was a nightmare. I should not full
around with Access security anymore. However, I learnt a
lot from fixing this problem... that's how we grow.

Oh, by the way, when I tried import my objects to a new
db, my form is imported nicely but its event's validation
in Vb (the codes) are not imported to the new one?

Many thanks again.

Kimmy
 
Back
Top