Continuous Password Requests

[Gail Williams]

Hi

I have written an asset management program in Access 2007 that's been in use for over two years. Access is restricted only by a password. This is a multi-user database that up to seven people use, usually about 3 in at any one time.

Today, instead of being asked for the password only on entry, users are being asked for the password on exit and when taking actions such as allowing macros to run.

To investigate, I tried taking the password off, but instead of the decrypt option, the ribbon shows the encrypt option. But when I tried that, all I got was a message box telling me the password was invalid.

This has become an issue today as I was planning to separate the database into front and back ends, but the constant requests for the password appear to be stopping the functionality.

Any idea how I can remove the password and move this on?

Thanks guys.

[Mihail]

Hm.
Try to change the computer system date to a preview one (say 1 year before now) and see what happen.
Maybe you had programming some kind of protection that make the database available only until yesterday.

As far as I know, in your situation, is nothing to do.
Maybe to pay for a hacker :) .

You can try:
- Compact and repair feature from Access
- Open the database on other computer
- Reinstall Access (better entire Office)
- Reinstall operating system

but I have serious doubt that will work.

[Gail Williams]

Hi Mihail

Thanks for the response, you've confirmed my own thoughts on this one. I had already tried the first two points with no improvement before posting, but not the second two as the company I work for runs terminal services so reinstalling is unlikely to be approved by the IT Manager. However, I did find a copy of the database from a couple of weeks ago that is still working, so I guess my best option is to copy that and migrate the more recent data across.

Thanks for the help.

[Mihail]

And make backups. A lot of backups.

[Gail Williams]

Good advise, will take it.

Thanks