Access 2003 requires password to create a new blank database

[archuleta37]

I have an issue where Access 2003 requires password to create a new blank
database. Also, when I try to open an existing .mdb file I'm prompted for a
password. My windows login is autofilled for the username. I tried my windows
logon password but no luck. I have all of the latest service packs and
patches. Any idea what could be causing this?

 

['69 Camaro]

Hi.

Any idea what could be causing this?

Yes. You're joined to a workgroup that has the password set for the default
Admin user. Either you can join a workgroup where the password isn't set,
or you can remove the password if you're joined to the default workgroup.
Please see the tip "How to open databases and only be prompted for User ID
and password for the secure databases" on the following Web page:

http://www.access.qbuilt.com/html/security.html

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[archuleta37]

that did the trick, thanks for the link

Hi.


Yes. You're joined to a workgroup that has the password set for the default
Admin user. Either you can join a workgroup where the password isn't set,
or you can remove the password if you're joined to the default workgroup.
Please see the tip "How to open databases and only be prompted for User ID
and password for the secure databases" on the following Web page:

http://www.access.qbuilt.com/html/security.html

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

['69 Camaro]

You're welcome. Glad to help.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.