I set up Security on my Db using the user level security wizard. once the
wizard was finish and all passwords set up i restarted acces 2007 and put in
the username and password. this wasnt the problem, the problem was when i try
and creat a new Db it asks for a logon which i didnt want to happen plus when
i put in the user names and passwords i set up before, a message pops up
telling me the username and password are incorrect. i also cant remove the
security i have set up. so anyone that knows how to please help me

Thank you for your time.

Access has changed the default mdw to the secure one you created. Use the
workgroup administrator to rejoin system.mdw (do a search for it first).
Once rejoined to system.mdw, you can use a desktop shortcut to launch your
secure mdb. All other sessions of Access will use the default system.mdw
and not prompt for a login. The target of the shortcut would look like...
"path to msaccess.exe" "path to secure mdb" /wrkgrp "path to secure mdw"

When entering the username/password, might you be confusing a password for a
PID - they aren't the same. Try a username with a blank/null password.

As for removing security, the wizard would have created a backup of your
mdb - look in the folder for a file with the same name but a bak extension
(just rename it to have a mdb extension).

--
Joan Wild
Microsoft Access MVP
"Brendanpeek" <(E-Mail Removed)> wrote in message
news:08FD13DD-19B9-42C6-9822-(E-Mail Removed)...
>I set up Security on my Db using the user level security wizard. once the
> wizard was finish and all passwords set up i restarted acces 2007 and put
> in
> the username and password. this wasnt the problem, the problem was when i
> try
> and creat a new Db it asks for a logon which i didnt want to happen plus
> when
> i put in the user names and passwords i set up before, a message pops up
> telling me the username and password are incorrect. i also cant remove the
> security i have set up. so anyone that knows how to please help me
>
> Thank you for your time.

Seach did not return any files

"Joan Wild" wrote:

> Access has changed the default mdw to the secure one you created. Use the
> workgroup administrator to rejoin system.mdw (do a search for it first).
> Once rejoined to system.mdw, you can use a desktop shortcut to launch your
> secure mdb. All other sessions of Access will use the default system.mdw
> and not prompt for a login. The target of the shortcut would look like...
> "path to msaccess.exe" "path to secure mdb" /wrkgrp "path to secure mdw"
>
> When entering the username/password, might you be confusing a password for a
> PID - they aren't the same. Try a username with a blank/null password.
>
> As for removing security, the wizard would have created a backup of your
> mdb - look in the folder for a file with the same name but a bak extension
> (just rename it to have a mdb extension).
>
> --
> Joan Wild
> Microsoft Access MVP
> "Brendanpeek" <(E-Mail Removed)> wrote in message
> news:08FD13DD-19B9-42C6-9822-(E-Mail Removed)...
> >I set up Security on my Db using the user level security wizard. once the
> > wizard was finish and all passwords set up i restarted acces 2007 and put
> > in
> > the username and password. this wasnt the problem, the problem was when i
> > try
> > and creat a new Db it asks for a logon which i didnt want to happen plus
> > when
> > i put in the user names and passwords i set up before, a message pops up
> > telling me the username and password are incorrect. i also cant remove the
> > security i have set up. so anyone that knows how to please help me
> >
> > Thank you for your time.
>
>

and once i have found it how do i rejoin it

"Joan Wild" wrote:

> Access has changed the default mdw to the secure one you created. Use the
> workgroup administrator to rejoin system.mdw (do a search for it first).
> Once rejoined to system.mdw, you can use a desktop shortcut to launch your
> secure mdb. All other sessions of Access will use the default system.mdw
> and not prompt for a login. The target of the shortcut would look like...
> "path to msaccess.exe" "path to secure mdb" /wrkgrp "path to secure mdw"
>
> When entering the username/password, might you be confusing a password for a
> PID - they aren't the same. Try a username with a blank/null password.
>
> As for removing security, the wizard would have created a backup of your
> mdb - look in the folder for a file with the same name but a bak extension
> (just rename it to have a mdb extension).
>
> --
> Joan Wild
> Microsoft Access MVP
> "Brendanpeek" <(E-Mail Removed)> wrote in message
> news:08FD13DD-19B9-42C6-9822-(E-Mail Removed)...
> >I set up Security on my Db using the user level security wizard. once the
> > wizard was finish and all passwords set up i restarted acces 2007 and put
> > in
> > the username and password. this wasnt the problem, the problem was when i
> > try
> > and creat a new Db it asks for a logon which i didnt want to happen plus
> > when
> > i put in the user names and passwords i set up before, a message pops up
> > telling me the username and password are incorrect. i also cant remove the
> > security i have set up. so anyone that knows how to please help me
> >
> > Thank you for your time.
>
>

Be sure to include system and hidden folders in your search.
Hit Ctrl-G and type
Docmd.RunCommand acCmdWorkgroupAdministrator
By the way, when you ran the wizard, you created a new workgroup file,
right?

Otherwise you may have modified the standard system.mdw.

--
Joan Wild
Microsoft Access MVP
"Brendanpeek" <(E-Mail Removed)> wrote in message
news:0BDD3B59-2C21-4772-A894-(E-Mail Removed)...
> and once i have found it how do i rejoin it
>
> "Joan Wild" wrote:
>
>> Access has changed the default mdw to the secure one you created. Use
>> the
>> workgroup administrator to rejoin system.mdw (do a search for it first).
>> Once rejoined to system.mdw, you can use a desktop shortcut to launch
>> your
>> secure mdb. All other sessions of Access will use the default system.mdw
>> and not prompt for a login. The target of the shortcut would look
>> like...
>> "path to msaccess.exe" "path to secure mdb" /wrkgrp "path to secure mdw"
>>
>> When entering the username/password, might you be confusing a password
>> for a
>> PID - they aren't the same. Try a username with a blank/null password.
>>
>> As for removing security, the wizard would have created a backup of your
>> mdb - look in the folder for a file with the same name but a bak
>> extension
>> (just rename it to have a mdb extension).
>>
>> --
>> Joan Wild
>> Microsoft Access MVP
>> "Brendanpeek" <(E-Mail Removed)> wrote in message
>> news:08FD13DD-19B9-42C6-9822-(E-Mail Removed)...
>> >I set up Security on my Db using the user level security wizard. once
>> >the
>> > wizard was finish and all passwords set up i restarted acces 2007 and
>> > put
>> > in
>> > the username and password. this wasnt the problem, the problem was when
>> > i
>> > try
>> > and creat a new Db it asks for a logon which i didnt want to happen
>> > plus
>> > when
>> > i put in the user names and passwords i set up before, a message pops
>> > up
>> > telling me the username and password are incorrect. i also cant remove
>> > the
>> > security i have set up. so anyone that knows how to please help me
>> >
>> > Thank you for your time.
>>
>>