473,574 Members | 2,269 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Running Access over Citrix

Rob
I am an Access developer and have done many Access databases in the
standard Front-end on the workstations, backend on the server
(over a LAN) but have never worked with Access over Citrix, though
that situation is coming up for me shortly.

Question: When you run the front-end on the Server, does Citrix clone
the front
end application database file for each user that connects or do they
all connect
to physically the same front-end file?
The real question here is: If user1 adds rows to a table that is
local in the
front-end will user 2 be able to see those records (assuming they have
the
proper table permissions)? If they were running in physically the
exact same
front-end file, they would be able to see each others records. If
Citrix gives
each user their own workspace and a copy of the front-end, they
wouldn't.
Any enlightenment you could provide would be appreciated.
Thanks
Nov 13 '05 #1
7 8130
si****@ensco.co m (Rob) wrote:
I am an Access developer and have done many Access databases in the
standard Front-end on the workstations, backend on the server
(over a LAN) but have never worked with Access over Citrix, though
that situation is coming up for me shortly.

Question: When you run the front-end on the Server, does Citrix clone
the front
end application database file for each user that connects or do they
all connect
to physically the same front-end file?
The real question here is: If user1 adds rows to a table that is
local in the
front-end will user 2 be able to see those records (assuming they have
the
proper table permissions)? If they were running in physically the
exact same
front-end file, they would be able to see each others records. If
Citrix gives
each user their own workspace and a copy of the front-end, they
wouldn't.


While it may be possible that Citrix gives you the option of copying down a new FE
for each user that hasn't been my experience. AFAIK you must do this yourself.

I specifically created the Auto FE Updater utility so that I could make changes to
the FE MDE as often as I wanted and be quite confident that the next time someone
went to run the app that it would pull in the latest version. For more info on the
errors or the Auto FE Updater utility see the free Auto FE Updater utility at
http://www.granite.ab.ca/access/autofe.htm at my website to keep the FE on each PC up
to date.

In a Terminal Server or Citrix environment the Auto FE Updater now supports creating
a directory named after the user on a server. Given a choice put the FE on the
Citrix server to reduce network traffic and to avoid having to load objects over the
network which can be somewhat sluggish.

Also see the TempTables.MDB page at my website which illustrates how to use a
temporary MDB in your app. http://www.granite.ab.ca/access/temptables.htm

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
Nov 13 '05 #2
I have a 250 MB Access database with 6 users that was run over a LAN
for 2.5 years. For performance reasons it was moved to a Citrix server
3 weeks ago and runs significantly faster.

The problem is that users sometimes get Not Enough Memory messages.
They will typically have open 3 other programs, Excel, Lotus Notes and
Word. It isn't reasonable to ask them to close those programs.
Everyone loves the speed of the citrix, but we will have to move back
to the LAN if we can't stop the Not Enough Memory messages. The IT
guys thinks our computers aren't powerful enough, but they have a 2.4
GHz CPU and 515 MB RAM. Shouldn't running a db over citrix requires
less memory? Company wide our LAN is overloaded and slow, but yet the
citrix is virtually unused. I don't know much about networks/servers,
but I have to wonder if it's set up correctly. If the IT guy does know
what he's doing, Citrix doesn't seem to be such a great option.

Nov 13 '05 #3
"neptune" <bs**********@h otmail.com> wrote in message
news:11******** **************@ z14g2000cwz.goo glegroups.com.. .
I have a 250 MB Access database with 6 users that was run over a LAN
for 2.5 years. For performance reasons it was moved to a Citrix server
3 weeks ago and runs significantly faster.

The problem is that users sometimes get Not Enough Memory messages.
They will typically have open 3 other programs, Excel, Lotus Notes and
Word. It isn't reasonable to ask them to close those programs.
Everyone loves the speed of the citrix, but we will have to move back
to the LAN if we can't stop the Not Enough Memory messages. The IT
guys thinks our computers aren't powerful enough, but they have a 2.4
GHz CPU and 515 MB RAM. Shouldn't running a db over citrix requires
less memory? Company wide our LAN is overloaded and slow, but yet the
citrix is virtually unused. I don't know much about networks/servers,
but I have to wonder if it's set up correctly. If the IT guy does know
what he's doing, Citrix doesn't seem to be such a great option.


Which machine is reporting the memory error, the Citrix Server or their local
PC? Running a Citrix client should take considerably less resources than
running Access.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #4
Which machine is reporting the memory error, the Citrix Server or their local PC? Running a Citrix client should take considerably less resources than running Access.


The memory error is on the PC, while running the database through
Citrix, but yet no memory errors when running off the much slower LAN.

Nov 13 '05 #5
neptune wrote:
Which machine is reporting the memory error, the Citrix Server or
their local PC? Running a Citrix client should take considerably
less resources than running Access.


The memory error is on the PC, while running the database through
Citrix, but yet no memory errors when running off the much slower LAN.


I understand that the message is being *seen* on the local PCs, but is it
only being seen when they are actively using the Access app? That might
mean that it is still the server that is sending the low memory message. It
is far more likely that you are overloading the resources *on the server*
and Citrix is sending these messages back to the client users.

What version of Windows and Access on the server? Server 2003 doesn't like
Access 97.
Nov 13 '05 #6
The server runs Access 2000 (9.0.6926 SP-3), precisely what the
majority of users have on their desktop. On citrix, I only have access
to this application and don't know anything about the version of
Windows. I can't tell from the error message whether it's on the
server or PC. It says "There isn't enough free memory to update the
display. Close unneeded programs and try again." The message is
only seen when actively using the Access app. The citrix server farm
is virtually unused so I can't imagine the problem being that the
server is over taxed. While the app runs very fast on the citrix, I've
also seen it completely freeze up while not running a query or doing
anything else.

Nov 13 '05 #7
neptune wrote:
The server runs Access 2000 (9.0.6926 SP-3), precisely what the
majority of users have on their desktop. On citrix, I only have
access to this application and don't know anything about the version
of Windows. I can't tell from the error message whether it's on the
server or PC. It says "There isn't enough free memory to update the
display. Close unneeded programs and try again." The message is
only seen when actively using the Access app. The citrix server farm
is virtually unused so I can't imagine the problem being that the
server is over taxed. While the app runs very fast on the citrix,
I've also seen it completely freeze up while not running a query or
doing anything else.


That particular error is not unusual from Access so I would be willing to bet
that the error is coming from the server, not the local PC.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
6004
by: Will Seay | last post by:
At the end of this message I've pasted a script we're trying to modify slightly. I don't believe it is VBscript or javascript but these are the closest groups I could find with my limited programming knowledge. Basically, we are trying to add a few lines to this script that will execute a few shell commands (see comments at the very end of...
3
4582
by: Mike Thomas | last post by:
In Access 2000, Win NT, Citrix, we have each user opening the front end mdb in their own folder, and linnking to the back end. I've noticed that a user can get more than one instance open at a time if they are not careful. Is there a way to have an instance of Access check to see whether there is another one already open for this user, and...
5
2737
by: Lakbir Dhillon | last post by:
We converted our databases from Access 97 to Access 2002 (only the MDB files, not the MDW file). In addition we ported the Access application from a Citrix NT server to a Citrix XP server. We users accessing the application Globally via the Citrix Servers and have been experiencing the following error on a daily basis: Disk or...
7
6762
by: Adam Barnett via AccessMonster.com | last post by:
I have an Access application split into a FE and BE with a workgroup file (.mdw) for authentication. I currently have the FE application setup as a published application for 40 users. We have been experiencing some unusual behavior that was not experienced when the application was run in a client/server environment. What is the proper way to...
0
1349
by: Edwinah63 | last post by:
Hi Access Gurus, can you tell me if Access can be made Active Directory aware? we would like to link the database Login to the Citrix Client Login. this way, users would not have to log in twice - once to Citrix and once to the Database - just the once so when they log in to Citrix they can just open the database and their permissions...
33
3241
by: DFS | last post by:
An application I wrote has been deployed on Citrix, and the Citrix admin tells me all users run the same .mde file. There aren't a lot of concurrent users, but even 2 could be cause for concern. I think the use of globals is worrisome in this case. Anybody have any experience with Access on Citrix? (Al Kallal already griped me out about...
2
10173
by: Tim Diggle | last post by:
I'm trying to enter data into a database application running under Citrix ICA Client. I'm doing it from a VBA macro running under Microsoft Excel 2000 (although it may need to be backwardly compatible with '97). I'm doing this by using appactivate to activate the database application, then sendkeys to send strings of data and tab characters...
43
4213
by: James Stewart | last post by:
If I were to begin creating a fairly simple database, i.e. a datasheet that would include two related tables to create an encyclopedic style database and then create some fairly indepth forms to filter and query the info in the database, would there be any great advantage to upgrading from Access97 to a later version?
3
2522
by: Blaize | last post by:
We are having locked database issues with having an MDE file which we added for our Citrix users. The Citrix users are added to a specific group in Active Directory which allows them to access the MDE file. Works fine for the first person to access the MDE file, if someone else connects up to Citrix and clicks on the shortcut they get a message...
0
7826
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7741
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
1
7838
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
6491
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5637
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3763
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
2257
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1362
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1090
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.