Avatar of ryanvmcgee
ryanvmcgee asked on

Cannot Create database in ACT 2007. Access is denied.

Hello,

We have just recently installed Act 2007 in our office.    All of the computers are up and running except for one.   We have one copy of ACT running on our server.  The server hosts the main database and provides the other computers with remote databases via syncronization.  

On the computer that isn't working:    I have installed ACT and the required SQL server 2005.  Everything appears to have installed correctly.  However when I open act and attempt to create any databases I receive this error message:

**Directory lookup for the file"C:\Documents and Settings\VicM\My Documents\ACT\ACT for Windows 9\Databases\Vicm.ADF" failed with the operating system error 5(access is denied)."**

It's almost as if it thinks it can't save files to the my documents folder.   I've checked all the permissions and they're set correctly for this computer.   Any Ideas??
ACTContact ManagementMicrosoft SQL Server 2005

Avatar of undefined
Last Comment
ryanvmcgee

8/22/2022 - Mon
Murtie


Have you checked whether this file exists:
C:\Documents and Settings\VicM\My Documents\ACT\ACT for Windows 9\Databases\Vicm.ADF

Have you checked the permissions for the user that you are trying to login with, even on the database?

ASKER
ryanvmcgee

Act is supposed to be creating the database when I get the error.  However,  for some reason it does actually create the file.  But then if i try to open it manually I still get the same error.   As far as I know the permissions are all good.  There are no specific permissions that can be set to just the database.
Mike Lazarus

Maybe try this article in the ACT! Knowledge Base - http://tinyurl.com/4wsj5x
Your help has saved me hundreds of hours of internet surfing.
fblack61
Mike Lazarus

If not, are you running Vista?
ASKER
ryanvmcgee

No windows XP Pro.
ASKER
ryanvmcgee

I'm sorry I thought I posted a reply to the Act Knowledgebase comment.   I've already tried that and I'm running XP Pro.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Mike Lazarus

Are you a local administrator in Windows?
ASKER
ryanvmcgee

yes
Mike Lazarus

Try creating the database in c:\act\databases
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
ASKER
ryanvmcgee

Ok,   Tried it but I still get an error message.   The message says" Failed to update database "VicM" Because the database is read-only.      
Mike Lazarus

It's a preferences issue on that machine... are you sre the acocunt you log into Windows with is a local admin?
ASKER
ryanvmcgee

Ok I double checked to see if maybe somehow his accout was not the admin localy on the computer but,  it is setup as a local admin.  I was sure that was going to work.   Any other ideas?
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Mike Lazarus

Try creating a folder - c:\act\database
Try saving the file there
ASKER
ryanvmcgee

So I FOUND THE SOLUTION!!

Nothing I could find here or on microsoft would work.  This is obviously a rare error.
:
Running an XP repair would not work so I FULLY REINSTALLED WINDOWS XP PRO.   This worked!    

I made sure to re-install Act before any other software to avoid any complications with other programs.

All is good and hopefully someone else may be looking for this same solution.

Thanks for your help GLComputing!
ASKER CERTIFIED SOLUTION
Mike Lazarus

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
ryanvmcgee

Thanks GL  but I've already got everything up and running.

I installed ACT First But installed Office before actually running Act for the first time.  That seemed to work.  

Thanks Again!
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy