Terminal Sever with VPN and MSAccess

[romh]

Hi. I finally got the VPN from home to the office working.
I also installed Terminal Sever in the VPN server and it works beautifully from home. I have two questions:
1) I have an MS Access database at work. I am able to open it and use it perfectly. Slower than if I were at work, but it still works. The problem is that the colors don;t come out right. The form's background colors aren;t beeing displayed. All I get are a bunch of dots. Why doesn;t the terminal server diplay the colors correctly? I know for a fact that its not the VPN, because even within the LAN from work, the terminal sever displays the same dots.

2) Is the processor of the server and amount of memory directly related to the performance / speed of the terminal services from the client side? In other words, will a bigger CPU and more memory make a big impact on speed on the other side of the VPN and terminal client. Currently, the VPN server/ terminal server / database server / IIS server... is only 700 MHZ with 256 MB ram. Furthermore, it has 10 client in the local LAN accessing the database at all times.

I don;t think this machine will be adequate once 1 or two remote offices start connecting all day long to the database.

Thanks

 

[romh]

figured question 1 out. Terminal Server in Windows 2000 only supports 256 Colors.

Can somebody answer question #2 please.

 

[kilt]

Hi Romh - I had the same problem as you (& stll do). i couldn't open our access database over VPN so i started using TS. The database can now be opened but some of the larger queries make the database unstable & we have a 1.8 Gb Pentium 4 CPU & 1.5 Gb RAM + this is when there is only one user logged on to TS. Im looking at third party applications just now but I've been told that the best answer its to have another licensed Win 2000 server with Terminal Server installed in Application Mode - more money & IT admin time required. If I find a solution, I'll let you know.

Kilt