Using Terminal with access

[Roy Goldhammer]

Hello there

One of my clients have a many users who using my Access program. with
diffrent locations.

In order to reduce the cost of servers he placed one server on one of the
stations, and connect other users to the server Using terminal server.

But, in this way the program works very slow, and in some cases when the
user is trhying to run huge reports he gets an error of Out of memory.

This is occur only to users who connected via terminal service.

Does enyone knows what can cause this problem?



--
øåòé âåìãäîø
òúéã äðãñú úåëðä
èì' 03-5611606
ôìà' 050-7709399
àéîééì: (e-mail address removed)

 

[Rick Brandt]

Hello there

One of my clients have a many users who using my Access program. with
diffrent locations.

In order to reduce the cost of servers he placed one server on one of
the stations, and connect other users to the server Using terminal
server.
But, in this way the program works very slow, and in some cases when
the user is trhying to run huge reports he gets an error of Out of
memory.
This is occur only to users who connected via terminal service.

Does enyone knows what can cause this problem?

How many users and what kind of hardware on the server? You need a pretty
robust machine to host Access apps on Terminal Server if there are more that
just a few users connecting.

 

[Albert D.Kallal]

First, we assume that you split the database.

You can read why here:

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

however, when you run terminal services, everything actually stays on the
server. However, you STILL NEED to provide a SEPARATE front end (preferably
a mde) for each user that logs on. So, this mde front end will be on the TS
machine..but EACH USER MUST get their own copy of the front end...

 

[Rob Oldfield]

How many users and what kind of hardware on the server? You need a pretty
robust machine to host Access apps on Terminal Server if there are more that
just a few users connecting.

Just along the same lines as Rick... it would also be worth monitoring the
performance of the TS box e.g. memory and CPU usage.

Just to check something. The line "In order to reduce the cost of servers
he placed one server on one of the stations..." worries me. You do have a
separate server box running it. Yes?