Anybody using Citrix to present an MS Access app to users?

[Tony Toews [MVP]]

I've always used 128MBs per simultaneous user as a rule of thumb. My
experience is that this is a pretty generous allowance.

A client setup a 2 Gb system for about 25 users of Access, Word, Excel
and other apps. They never got past 1 Gb.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[David W. Fenton]

Per David W. Fenton:

Good segue....-)

What does Citrix do that terminal server does not?

Costs more? It supposedly makes certain things easier, but I've
never encountered problems with WTS. For the printer issue, it's
easy enough to handle, simply by making sure you've got the right
printer drivers installed on the Terminal Server.

App-in-a-browser-window sounds like it might be one.

That might be one, but it doesn't sound very attractive to me, since
it's no doubt ActiveX-based, and thus IE-only.

 

[David W. Fenton]

VNC

Er, what? Did you mean VPN? I said *without* a VPN.

VNC I'd just never use for production work, as it's just way too
slow. WTS, of course, is a different animal.

How much of the IT network is under your control? Next to none
likely.

That all depends on the client, but at least if something's wrong
and it's end-to-end controlled by one company, it's a lot easier to
get problems fixed.

 

[AltaEgo]

Citrix handles printers much better than TS. So what I did was give
the users the ability to email themselves all reports as PDF files.
Citrix also handles other things, but what they are I have no idea.

Tony

We've just ported a database over to Citrix. All of the email modules
produced errors and need re-writing. Since I am unfamiliar with how to
automate email through Citrix, I don't know where to start. No doubt, a few
rudimentary lessons will get me up & running but, for now it is a major
hurdle.

Directory navigation with VBA also seems to produce some interesting
challenges.

 

[Steve Schapel]

David,

My experience is that this is not necessarily true. I understand that
this does not necessarily work with any printer, particularly USB
connected printers, and a lot of multi-function devices.

 

[Tony Toews [MVP]]

Er, what? Did you mean VPN? I said *without* a VPN.

VNC I'd just never use for production work, as it's just way too
slow. WTS, of course, is a different animal.

Brain fart at my end. I meant to type VPN.

That all depends on the client, but at least if something's wrong
and it's end-to-end controlled by one company, it's a lot easier to
get problems fixed.

True enough. Hmm, that's a good point. If I was going to make an
app work via SQL Server over the Internet I'd code a ping test or
something similar. Just about anything so if there were troubles
somewhere or they were setting things up they could use the tool to
confirm that the problem is not in my app.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Tony Toews [MVP]]

We've just ported a database over to Citrix. All of the email modules
produced errors and need re-writing. Since I am unfamiliar with how to
automate email through Citrix, I don't know where to start. No doubt, a few
rudimentary lessons will get me up & running but, for now it is a major
hurdle.

That depends on your email client. Try posting some questions with a
new subject and some details including code and error messages.

I'm using some VBA code which goes directly against the Winsock API
however I'm unable to share that code.

Directory navigation with VBA also seems to produce some interesting
challenges.

I can well imagine. But again start another thread with some details.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[david]

Our WAN customers are happier with Citrix than they are
with ODBC.

There is a wide variation in WAN speed, but straight
Access/SQL Server seems to run slower than Citrix..

(david)

 

[Tony Toews [MVP]]

Our WAN customers are happier with Citrix than they are
with ODBC.

There is a wide variation in WAN speed, but straight
Access/SQL Server seems to run slower than Citrix..

Good to know. Trouble is I can see some situations coming up where
Citrix/TS would cost the client some $$$s for my app however giving
them an SQL Server connection via VNC over the Internet would not cost
them $$$.

Also if other clients insist on using wireless in the LAN which I can
also see happening.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[(PeteCresswell)]

Per Tony Toews [MVP]:

Also if other clients insist on using wireless in the LAN which I can
also see happening.

At my current #1 customer's site, this is becoming more and more
widespread. Seems like the majority of employee PC's are now
laptops and they new ones are all coming through with onboard
WiFi.

 

[Tony Toews [MVP]]

At my current #1 customer's site, this is becoming more and more
widespread. Seems like the majority of employee PC's are now
laptops and they new ones are all coming through with onboard
WiFi.

Ayup. And these folks are also going to whine, err mention, why can't
they access their data while at home or at a clients or elsewhere.
And they do have a point.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[David W. Fenton]

giving
them an SQL Server connection via VNC over the Internet would not
cost them $$$.

You mean VPN. VPN, Tony, not VNC.

 

[Tony Toews [MVP]]

You mean VPN. VPN, Tony, not VNC.

AAARGGGHHHH. Why do I do that. It's been years since I used VNC.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/