01-24-2015 02:04 PM
This is the second time ACT! has locked me out of a database by asking for a "password." I have NEVER used a password to access my databases.
Is there an explanation for this? What are my options? I'm SERIOUSLY considering going to another program!
Thanks in advance
Frustrated in NC
01-26-2015 06:40 PM
This problem turned out to be quite a bit different than I was expecting. The issue was that the syscommittab problem corrupted the database which made the database inaccessible. The fix was to stop the SQL server, move the database, restart the SQL server, run actdiag and delete the reference to the database, run the syscommittab fix and then install SQL 2008 R2 SP3. I'm posting this information for the benefit of the next person that runs into this issue and finds that they can't even get into the database. The error message when running actdiag was that the database was already open and couldn't be opened again.
Stan
01-24-2015 03:10 PM
01-24-2015 06:30 PM
01-24-2015 09:47 PM
Have you tried just pressing enter?
Stan
01-25-2015 02:05 PM
01-25-2015 03:12 PM
When you add a second user to the database it starts requiring that the users log in.
Stan
01-25-2015 04:44 PM
01-25-2015 05:21 PM
The only other thing I've seen do it is when someone inadvertantly puts a password on their account. Doesn't sound likely in this case so I don't know what might have caused it.
Stan
01-25-2015 06:34 PM
01-25-2015 07:30 PM
Swiftpage can get you back in your database and there are several ACCs that can get you back in your database. I don't know if Swiftpage will do it for free. They might or you can sign up for a support plan. ACCs make a living by billing for their time so as a rule they won't do it for free. There are some tools on the internet that you can purchase that will let you reset your password but none of them are free either. It's possible that you don't actually have a password but that you are simply keying in the wrong username. That might be worth a try. I can reset your password but I don't do it for free.
Stan