Solved

ACT the db you are trying to access has been locked by an administrator

Posted on 2011-03-14
3
1,320 Views
Last Modified: 2012-06-27
I closed down a ACT DB I was working in and began a new DB, when I retunred to the previous DB, I got the message the db you are trying to access has been locked by an administrator, tried, closing and reoping ACT and still same problem, can anyone help me? Thanks.
0
Comment
Question by:Asmithbbm
  • 2
3 Comments
 
LVL 20

Expert Comment

by:CompProbSolv
ID: 35130329
I'm not sure about version 11 (I'm using 12), but newer versions use a database engine to manage the file.  Have you restarted the computer that hosts the data file?
0
 
LVL 7

Expert Comment

by:50cal
ID: 35130400
The database has been locked by an Administrator, you can unlock the database by logging into the database as an Administrator and choosing "Tools -> Database Maintenance -> Lock/Unlock Database".

Alternatively you can log onto the Act Database Server and unlock via Act Diag
1. Log onto the Act Database Server
2. Select Start -> Run (or use the windows search box)
3. Type Act Diag and Press Return
4. Select Database -> Database List
5. Select your database by click it
6. Right Click your Database and select Unlock Database

You may want to check that no-one has locked it to make field changes before you unlock it as it may cause issues.

50cal.
0
 
LVL 7

Accepted Solution

by:
50cal earned 500 total points
ID: 35130409
In step 3 you type ActDiag with no space.

50cal.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Best way to segregate branch information 6 530
replace act6.0 database 14 563
Duplicate items on Notes/History Report in Sage ACT! 3 1,108
Act! version 16 freezing when launched. 8 98
A lot of users new to ACT!, especially those who don't get the benefit of a consultant, seem confused between when to share on a network and when to sync ... or, in fact, how to do either. So I thought I would attempt to explain the various options …
ACT LINK FOR PEACHTREE WON’T LINK PROBLEM       It always seems that when you upgrade Act or Peachtree Quantum in versions 2009, 2010, 2011, or 2012 then try to relink them it fails. Following the linking instructions-  Go to the peachtree tab in …
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

948 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now