Tags:
Symantec, Peachtree, Complete Accounting 2007 single user, VPN & SBS 2003 & Windows Vista
We have just setup VPN connection with SBS 2003 as the server. Most of our computers, though not all connecting to server are vista based. VPN connecting and reading mapdrive and all files such as words, exell with no problem. The problem is setting up Peachtree Complete Accounting 2007 (NOT multi user version). We are unable to connect it to the server (open any company). When we try for it to read data from the map drive z, it times out and gives error of pervasive 9. On another computer, it would say database on computer unavailable. Peachtree suggests us to buy Peachtree Premium Multiuser 2008. It is very expensive. I want to make sure this will work before buying/ upgrading. Or do you know if Peachtree Complete multi user version work too? Can anyone help? Thank you so much
I don't know that what you are looking to do is feasible, even with a sweet 6 meg DSL connection it would take over 8 minutes to download all of the data. (I know not all of the data is downloaded) - The company file seems too large. Please note that on a 6 Mb/s DSL connection the upstream is normally 768 Kb/s, sometimes 1.5 Mb/s.
Here is the math I used 6 Mb/s x 1000 (1000 Kb in 1 Mb) = 6000 Kb/s 6000 Kb/s DSL / 8 (8 bits in 1 byte) = 750 KB/s down 384 MB x 1000 (1000 KB in 1 MB) = 384,000 KB 384,000 KB / 750 KB/s = 512 s 512 s / 60 = 8.53 minutes
It just does not seem like you have enough bandwidth, there are also some other limiting factors such as upload speed from the other end. I would suggest something like terminal services or a virtual server that clients can remote to access this program / file at the office where the data is located.
To answer your question no I don't think that Peachtree Premium Multiuser 2008 will solve your problem.
If you company file is 340 MB - Peachtree is probably 'timing out' while trying to read the file over the network (your VPN). The non-peachtree folder probably has many smaller files in it and for programs similar to Microsoft Office I don't believe there is a timeout period the computer will just hang until it gets what it needs to open the file (which may be 100 KB 500 KB 1 MB etc). The file sizes for you documents are much smaller (although they total 341 MB). You don't have to read data from every file in the folder to open a Word Document, where you may need to read a good portion of the peachtree file to open the company data.
This is by the way only a suggestion as I have never attempted to open such a large company file over a VPN.
Yes using a remote desktop connection would be different as the computer you would access would be on the LAN of the server that is hosting the peachtree data. Essentially RDC and Terminal Services are the same thing, RDC is the program / method of connection to a computer with Terminal Services, which can be a Windows XP Professional PC or a Windows 2003 Server with Terminal Services Licenses. Please note that you may need a different version of peachtree if you are going to be using it in a terminal services environment .A terminal services connection is not the same as accessing the console of a computer / server and most programs will realize this and require a different license.
We run peachtree across a t1 and it is so slow as to be almost unusable. Remote desktop only works with Peachtree PREMIUM. you can get around this by having peachtree complete already open on the workstation you are connecting to. (you must use the same login name as the user who launched peachtree)
