Cannot use Access application due to password prompt

[Guest]

I'm unable to open and creat any MS Access DB file. When trying to open any
file, a password window pop up with Name and Password fild. In Name section
my Computer ID is already populated. I have not set up any password. I copied
the same MDB file to my other computer and was able to access the db without
any problem.

I can open an blank ADP file in MS Access and when I click on
Tool>>Security>>Database Security, I got the following error message. Error
Message: "The Database Administrative Component failed to load or
initialized. Verify that the components are installed and register locally".
Your help will be greatly appreciated. Thanks Fazal

 

[Joseph Meehan]

I'm unable to open and creat any MS Access DB file. When trying to
open any file, a password window pop up with Name and Password fild.
In Name section my Computer ID is already populated. I have not set
up any password. I copied the same MDB file to my other computer and
was able to access the db without any problem.

I can open an blank ADP file in MS Access and when I click on
Tool>>Security>>Database Security, I got the following error message.
Error Message: "The Database Administrative Component failed to load
or initialized. Verify that the components are installed and register
locally". Your help will be greatly appreciated. Thanks Fazal

How about a long shot; try copying your work group file from the machine
it is working on to the machine it is not working on

(NOTE: save a copy of the existing workgroup file before doing this, you may
want to be able to put it back.)

 

[Guest]

Thank you so much for your help. I'm not 100% sure how to do this but I'll
try this.
Thanks,
Fazal

 

[Norman Yuan]

See comment inline

I'm unable to open and creat any MS Access DB file. When trying to open any
file, a password window pop up with Name and Password fild. In Name section
my Computer ID is already populated. I have not set up any password. I copied
the same MDB file to my other computer and was able to access the db without
any problem.

I have no idea about this. It could have something to do with work group
security thing (which I never used). Try Joseph's suggestion.

I can open an blank ADP file in MS Access and when I click on
Tool>>Security>>Database Security, I got the following error message. Error
Message: "The Database Administrative Component failed to load or
initialized. Verify that the components are installed and register locally".
Your help will be greatly appreciated. Thanks Fazal

Access Project (ADP file) is a totally different thing from MDB file. Its
security is actually managed in the backend side(SQL Server/MSDE), which is
unlikely the cause of your problem.

 

[Guest]

Could you please help and let me know where (which folder) I can find the
Work Group files. Thanks Fazal

 

[Joan Wild]

Could you please help and let me know where (which folder) I can find the
Work Group files. Thanks Fazal

Use Start, Search and look for *.mdw

Open Access and go to Tools, Security, Workgroup Administrator. This will
show you the workgroup you are joined to by default. Click on Join and
rejoin system.mdw (whereever you found it above). That should get you back
in business.

However, if you only found one mdw file in your search and it is system.mdw
and you are already joined to it, then close Access, rename the system.mdw
to system1.mdw.

Reopen Access and it will create a new pristine system.mdw for you with no
login prompt.

If this works and you are able to get into your mdb, then just delete
system1.mdw and you're back to square one.