bobohost
asked on
Best Way To Move Quickbooks 2006 Database
Hello All,
I have a client that uses Quickbooks 2006 with 5 licenses. currently the database resides on the computer of the main user and it's setup as a share that other users also access. They would like to move the database to a network share so the database is always available to all users and it gets backed up. What is the best way to move a Quickbooks database from a computer to another server?
I have a client that uses Quickbooks 2006 with 5 licenses. currently the database resides on the computer of the main user and it's setup as a share that other users also access. They would like to move the database to a network share so the database is always available to all users and it gets backed up. What is the best way to move a Quickbooks database from a computer to another server?
When moving a QB file, the best way is to make a back up, then restore that back up to the new location. Just copying the .qbw file will not bring over templates, FAM or FSD files needed if you use them.
With 2006, I suggest installing the entire program on the server. While it's large, 2006 was the first year with the sybase background and using the database manager. Since Intuit will no longer support the product, having to trouble shoot any possible issues is easier with the full program installed.
With 2006, I suggest installing the entire program on the server. While it's large, 2006 was the first year with the sybase background and using the database manager. Since Intuit will no longer support the product, having to trouble shoot any possible issues is easier with the full program installed.
I generally do not recommend installing the whole program on a server as it has caused numerous problems. If you must, then do so, otherwise see if you can get it going without doing this.
stlinae is correct about FSD files, but not a lot of people use this feature. Basic QB templates and reports will come over with the ledger, but using the backup approach is also a good idea. ... Thinkpads_User
stlinae is correct about FSD files, but not a lot of people use this feature. Basic QB templates and reports will come over with the ledger, but using the backup approach is also a good idea. ... Thinkpads_User
ASKER
Ok I got the database on the server and it works fine unless I turn off the system that originally hosted the file. When that system is off I get an error that there is a problem with the computer that is hosting multi-user access to the QBW file.
On the system that originally host QB, open QuickBooks, and put the ledger into Multi-User mode. Then open QB on each other system and put them into multi-user mode.
Also make sure you are not using a "remembered" link to open the ledger. You copied it (copying is safer) or backed it up and so the ledger probably is still sitting on the first computer.
When you open QB, close it but do not exit. The use the function to open a ledger from a location (the open dialogue window) and point to the ledger on the server.
I think your problem is really "remembered" links. These links did not follow your changed location.
.. Thinkpads_User
Also make sure you are not using a "remembered" link to open the ledger. You copied it (copying is safer) or backed it up and so the ledger probably is still sitting on the first computer.
When you open QB, close it but do not exit. The use the function to open a ledger from a location (the open dialogue window) and point to the ledger on the server.
I think your problem is really "remembered" links. These links did not follow your changed location.
.. Thinkpads_User
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I see the "remembered link" problem all the time in any version of QB which is why I recommend it be tried. Also note the problem occurred with the first system turned off. QB multi-user and hosting can often work around turned-off systems so long as the ledger is on a separate server, which it now is.
QB2006 US was the first client server version and had some bugs, so the post above may be helpful as well. I use the Canadian version of QB and the client server started with V2008 with many bugs worked out. As you (bobohost) resolve your issue, you should consider upgrading to V2010.
... Thinkpads_User
QB2006 US was the first client server version and had some bugs, so the post above may be helpful as well. I use the Canadian version of QB and the client server started with V2008 with many bugs worked out. As you (bobohost) resolve your issue, you should consider upgrading to V2010.
... Thinkpads_User
ASKER
So I need to connect all the systems to the QB database and make sure they are in Multi User mode? Then close QB? How do I setup so it won't remember the ledger?
QuickBooks has a remembering function (like Excel or whatever).
Open QuickBooks. If it opens any ledger because it was last open, close the ledger (File, Close). Don't exit QB. Now see the dialogue box and use the big Open Company button. Now point it to your server ledger. It should open and now you can attend to Multi-User and turn off Hosting per the above comment.
You cannot unremember the links, but if you do it this way, the good link will be first in the list.
... Thinkpads_User
Open QuickBooks. If it opens any ledger because it was last open, close the ledger (File, Close). Don't exit QB. Now see the dialogue box and use the big Open Company button. Now point it to your server ledger. It should open and now you can attend to Multi-User and turn off Hosting per the above comment.
You cannot unremember the links, but if you do it this way, the good link will be first in the list.
... Thinkpads_User
Make a folder with the server folder structure and make sure the QB users have full read-write access to that folder. Copy the ledger to that folder. Install the server manager (on the QB CD) on the server on the same physical drive as the ledger folder. Scan for the ledger folder. Make sure QuickBooks on the workstations are not set for Hosting mode. Point QuickBooks to that folder/ledger.
If your QB Version does not have a server manager (older QB version). make the folder structure as above, copy the ledger into it and point QuickBooks to that folder/ledger.
When done, the server backup mechanism should back up the ledger. Otherwise use the regular QB Backup routine.
... Thinkpads_User