Access Prompts for Password After Compact/Repair

[Enge]

For whatever reason, after I compact and repair certain databases on our LAN, I am presented with the "Password Required" prompt the next time I attempt to open the database. The database is used by others, but I have confirmed that no one is placing a password on the databases in question. To complicate the situation, there is one PC that can sometimes access the databases without getting the prompt. There is never any trouble if the database is first copied down locally and then compacted and repaired.

I suspect this may be a version/patch issue with the Office/OS software and/or server(s), since I have discovered build and XPclient variations on the PCs in my department. Any insight would be appreciated!

 

[dumdum]

Is there actually a password for the Database? I'm a little confused so please bare with me...

1. When you compact and repair the database it is actually disengaging you from the database while you run those utilities. This could be why. Once it reattaches it's requiring the Password.

2. Is anyone opening it with "Exclusive Use"?

If you are repairing and compacting a database (backend tables) the best suggestion I can give you is to first make a copy of the database. The Repair and Compact the database. If during the process you have any problems you can replace the damaged DBS with the copy you made.



We are always looking for new members at our computer forums:

http://forums.jlrforum.net