How do I remove all default security setting from the Access program?
I try to put security on one file but seemed to have it on all access file
or database that i have put together prior to the initial one.
You likely miss understood how security works. When you launch ms-access,
you ARE ALWAYS joined to a security file. If you assign a password to the
admin user, then you will ALWAYS be prompted for a password. This security
file, and your logging into ms-access OCCURS BEFORE you open ANY ms-access
file.
So, either you have modified the default security file and assigned a
password to the admin logon. The instant you assign that password, you will
always have log into ms-access. You THEN OPEN the mdb file of your choice
(so, login, and security occurs BEFORE YOU OPEN ANY ms-access file).
The other possible (likely) situation is that you used the workgroup admin
program to join another workgroup. This workgroup was likely created for a
particular (one) mdb file, and the instant you join a workgroup file, then
that workgroup file is used when launching ms-access. So, the solution is to
join back to your original workgroup file, and thus you will NOT be prompted
for a password anymore.
Since it sound like you only want ONE mdb file secured, then you best use a
shortcut command to specify the workgroup file, and thus will ONLY be
prompted for logon, and passwords for that one particulate secured
application. (in a nutshell, don't join a workgroup file, but ALWAYS specify
a shortcut for the workgroup file).
