Solved

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

Posted on 2011-03-14
3
1,316 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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

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 …
Microsoft have a hotfix for Windows systems that will improve application that uses UTC dates and times - including Outlook, the Windows Event Viewer and many third-party applications. Most date and time stamps that are created and displayed in W…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

744 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

14 Experts available now in Live!

Get 1:1 Help Now