[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 312
  • Last Modified:

quickbooks 2007 server 2003 bussines

i have a server with 2003 business with quickbooks 2007 peer to peer when i do the payroll it takes forever to print out just 20 checks , i did not set up active directory (it helps the application run faster) or i need to get a new sever? i have just 3 workstations
0
crispa77
Asked:
crispa77
  • 5
  • 4
1 Solution
 
John HurstBusiness Consultant (Owner)Commented:
I don't understand the peer-to-peer comment. QuickBooks 2007 (US Version I assume) is likely the Client Server version (tell me if no). So you need to install the server application on the Server, and locate the ledger on the same physical driver as the QB server application. Point the server application to the ledger and then connect QB to that ledger. Turn on hosted access. Done like that, it should print reasonably well. Transactions are quite fast in the client server model. Reports can be slow, but once the data has come up, printing is quite fast. Also, if QB has been running for a while, see if there is a transaction log and if it has gotten too big (>100Mb). That can slow down QuickBooks. ... Thinkpads_User
0
 
crispa77Author Commented:
quickbooks 2007 it is running with a server with os win 2003, i did not set up active directory, i shared de data file and it's running peer to peer.
0
 
John HurstBusiness Consultant (Owner)Commented:
That may be your problem. QB2007 has a server install and that should be done. It is not an active directory issue. Install the server component, run it, and browse for the data file.
... Thinkpads_User
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
crispa77Author Commented:
but i already install quickbooks 2007 server version in the server , and  i shared the data base file peer to peer.
0
 
crispa77Author Commented:
and the hosting user mode is on
0
 
John HurstBusiness Consultant (Owner)Commented:
If you installed the server application as you said, then (a) turn off hosted mode on QuickBooks on the 3 workstations, make sure you browse to the ledger with the server application, and then do a fresh open at the workstation (open QB, close any active file, then use the open button to navigate to the ledger on the server.

If, after doing all this, it takes forever to print a few cheques, then there may be something else going on besides QuickBooks. Make sure also your QB transaction log is not big.
... Thinkpads_User
0
 
crispa77Author Commented:
i notice that the data file is 700 mb too big i guess that the issue, can i compress this file any way??
0
 
John HurstBusiness Consultant (Owner)Commented:
700 Mb is very big, and that is part of your problem. However, the new Client Server version is more transaction oriented and cheques are transactions (unlike lenghty reports), so I wonder if there are other issues that we have not thought of. Have you tried rebuilding the file? Never, never rebuild a file over the network. Copy it down to a workstation first. That may compress it a bit.   ... Thinkpads_User
0
 
crispa77Author Commented:
I did a portable file from the data file and it compress the file to 120 mb that was good, it was still slow but , i've got the new version QB2009 it helps a lot. thanks for your help
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now