07-26-2008 04:19 PM
Tried to copy db from desktop to laptop, and my laptop says that it could not be accessed, check network connection, check that database server is available. I don't want to use it on a network. I simply want to copy this so I can use it at home or on the road. I used a flash drive. I'm only using one computer at a time. I've always been able to use this in version 6 and in the beginning with version 10. What gives? I'm using the latest upgrades. I'm a simple user that only wants to print contact lists and not have 5 computers. schedule appointments and phone calls. I've been using Act since the beginning. I suspect that I need to switch or go back to version 6, but even that seems complicated.
Reading the message boards it seems to have something to do with Sql server.
07-27-2008 06:15 AM
07-29-2008 10:56 AM
Are you able to open other databases?
Check out the following knowledgebase article:
Focus on these sections:
07-29-2008 04:27 PM
I took a look and I was trying to do a straight "Restore." I got it to work using the "Restore as..." option as you had suggested, but after I do that it forces me to create an entirely new database, which I don't want to do every time. Is there an easier way to copy the database to my notebook when I need to? It worked fine in the earlier version of ACT!, and I remember it working until just recently in the version 2008, but not any more. I can't run it off of a networked database like some people, and transfering like this is my only real option. Thanks for your time!
07-30-2008 04:22 AM
Yes, it won't allow you to re-use the same database name since that one already exists on your laptop. You can either delete the old database prior to putting the new version back in with the same name (Tools|Database Maintenance|Delete Database) so you don't start building up copies with different names, ( see ACT! Knowledge Base article at http://tinyurl.com/57pemh ) or consider setting up synchronization (see ACT! Knowledge Base article at http://tinyurl.com/yuurda )
If you only do this once in a while and don't need to make changes to the database on your laptop, it would be a lot easier to use the first option.
07-31-2008 12:42 PM
Why would this work originally, even in version 10 and then all fo sudden stop working. (backup and restore) If I do synchro do I have to have two copies, keep in mind I only use 1 computer at a tim e.
08-01-2008 08:49 AM
If you cannot open any other databases, you need to make sure that the SQL instance is installed and running.
To do this, go to Start -> Run and type in Services.msc
Once in the Services window, scroll down and see if you have an entry listed as SQL Server(ACT7)
If you have this service, make sure it is set to Automatic and Started
If you do not have this service, that is the issue.
You'll need to reinstall SQL using the following kb article. It's for a different error, but same procedure to reinstall SQL with ACT installed