reports and terminal services

  • Thread starter Thread starter Newbie
  • Start date Start date
N

Newbie

Hi,

Scenario:
SQL Server BackEnd
Access FrontEnd loaded on each client PC

I have some reports that rely on records being inserted into local tables
ie. in the FrontEnd - Access. This is because they take far too long to run
by using queries. This works fine when people have access loaded on their
machine and the reports are exported as a snapshot to c:\reports

How can I achieve the same thing when users are using terminal services to
log on to the application? Will each user have to have a copy of the
database in their home directory?

How will the code that looks at the path c:\reports be re-written to take
account of the user that is logged on?
 
Newbie said:
Hi,

Scenario:
SQL Server BackEnd
Access FrontEnd loaded on each client PC

I have some reports that rely on records being inserted into local
tables ie. in the FrontEnd - Access. This is because they take far
too long to run by using queries. This works fine when people have
access loaded on their machine and the reports are exported as a
snapshot to c:\reports

How can I achieve the same thing when users are using terminal
services to log on to the application? Will each user have to have a
copy of the database in their home directory?

How will the code that looks at the path c:\reports be re-written to
take account of the user that is logged on?
Click to expand...

Yes, and Yes. Even without the temp table issue it is still best for each
user to have their own copy of the front end (even on Terminal Server).
 
Thanks but how do I write the code that looks at c:\reports to now look at
c:\username\reports?
 
....and/or...

Use Environ$("COMPUTERNAME") to grab the computer name. If it's the name of
your TS box (or one of them) then you need to replace the path. If it's set
up in the way that I would expect then each user should already have a
particular drive mapped to a personal area. So...

if Environ$("COMPUTERNAME") ="YourTSBox" then
path="h:\reports"
else
path="c:\reports"
end if
 
And / Or

If you have a good relationship with your network guy (as I did in a
previous life) have him create a file in the root of the C: drive in your
Terminal Server / Citrix box whose name is very unlikely to be found on a
users computer. I name chose was "IsCitrix.rmw". The code I used looked
like:

if len(dir("C:\IsCitrix.rmw")) > 0 then
' I am a Citrix Client
else
' I am a Desktop User
end if

This also allowed me to test on my desktop as though I were a Citrix client
simply by putting an empty file with this name in the root directory of my
development box.

Ron W
 
Back
Top