Cannot use Access application due to password prompt

F

Fazal

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
 
F

Fazal

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

Norman Yuan

See comment inline

Fazal said:
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.
Click to expand...

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
Click to expand...

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.
 
F

Fazal

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

Joan Wild

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


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.
 
Top