Access 2000 and Terminal Server

[Ben Pursley]

Does anybody have any good/bad opinions about their experience running
MSAccess in Terminal Server? I have 7 users running Term Server and an
instance of an Access 2000 App. The Application appears to have a memory
leak. And by the end of the day the server is creaping. Any opinions?

--ben

 

[Van T. Dinh]

Tony Toews has some info on Access / Terminal Server.

See his Web site:

<http://www.granite.ab.ca>

HTH
Van T. Dinh
MVP (Access)

 

[Tony Toews]

Does anybody have any good/bad opinions about their experience running
MSAccess in Terminal Server? I have 7 users running Term Server and an
instance of an Access 2000 App. The Application appears to have a memory
leak. And by the end of the day the server is creaping. Any opinions?

No idea. A client is happily running 5-10 A2000 users in a largish
app all day long on TS/Citrix Server without any problems.

How do you know it has a memory leak? Do the apps end up taking more
memory by the end of the day? What happens if they exit and go back
in?

Is A2000 SR-1 installed? Are you closing recordsets when finished
with them? Have you split the MDB into an FE and BE and given each
user their own copy of the FE?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm