Improve company productivity with a Business Account.Sign Up

x
?
Solved

ACT 2011 - Unable to Access Database

Posted on 2013-12-30
7
Medium Priority
?
681 Views
Last Modified: 2016-11-23
I'm testing a few new ACT 2011 (Version 13.1.111.0, Hot Fix 6) databases. I am encountering an unusual error when I try to open a database. When I create a database on the "C" drive and later open and close it, there are no errors. However, when a new ACT database is created on a removable USB drive (for example, drive "F:), I get an unable to access database error.

I'm using the username mark with no password on all of the databases. There are no other application errors on this particular computer (a Dell Inspiron with 6 G of RAM).

What could be causing the error?
ErrorLogin
0
Comment
Question by:Mark01
  • 3
  • 2
  • 2
7 Comments
 
LVL 23

Assisted Solution

by:David
David earned 80 total points
ID: 39748480
One thought, what's your O/S version?  Known problems with XP Home.

Also, I read that ACT 2011 must be set on a local drive only -- network or shared drives are not supported.
0
 

Author Comment

by:Mark01
ID: 39749338
Hi dvz,

The computer has Windows 7 Home Premium. I have the same version of Act installed on another computer (also with Windows 7 Home Premium) that also stores the Act database files on a removable USB drive and no errors occur on that computer.

Thanks,
Mark
0
 
LVL 30

Accepted Solution

by:
Mike Lazarus earned 1920 total points
ID: 39750271
Why are you putting it on a USB drive?
This is likely to only work on some drives and won't work if you plug the drive into another system as the machine name is part of the database (as it is with SQL) ... also, the USB MUST ALWAYS be plugged in before you start the computer
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
LVL 23

Expert Comment

by:David
ID: 39750286
So, are you using one set of database files on both machines, or are they separate devices?
0
 

Author Comment

by:Mark01
ID: 39750385
Hi GLComputing and dvz,

I store all data on a USB portable external hard drive for security. It is always connected to the computer via a hub. The ACT application is installed on the "C" drive. The ACT data files (.ADF) are on the USB Portable External Hard drive. SQL Server is installed on the "C" drive and the SQL Server database file is on the "C" drive.

The ACT installations and databases on the two computers are not related. They are used for different purposes. Both computers are not sharing the same set of database files.

Thanks,
Mark
0
 
LVL 30

Assisted Solution

by:Mike Lazarus
Mike Lazarus earned 1920 total points
ID: 39752920
It really shouldn't (and usually won't) work on a USB drive. Soetimes, if the drivers doesn't indicate that it's a USB drive, the system will think it's local and it might work
0
 

Author Comment

by:Mark01
ID: 39754659
Thank you, GLComputing and dvz.
0

Featured Post

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
Exchange database can often fail to mount thereby halting the work of all users connected to it. Finding out why database isn’t mounting is crucial and getting the server back online. Stellar Phoenix Mailbox Exchange Recovery is a champion product t…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…

601 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