Access and citrix

F

Frits van Soldt

We have several clients who are working with our Access application in a
Citrix environment. One of them after interting some records recieves the
message "Object variable or with block not set". After that all the fields
in the form show the value "#name?". Does anybody have any idea? All other
clients (including Citrix users) have no problem.
 
A

Arvin Meyer

Frits van Soldt said:
We have several clients who are working with our Access application in a
Citrix environment. One of them after interting some records recieves the
message "Object variable or with block not set". After that all the fields
in the form show the value "#name?". Does anybody have any idea? All other
clients (including Citrix users) have no problem.
Click to expand...

If you haven't done so already, split the database into front-end (code,
queries, forms, etc.) and back-end (data tables). Make a folder on the
Citrix server for each user, and put a copy of the front-end in it.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
T

Tom Wickerath

Hi Frits,

Every once in a while I also get this error, although I'm not using Citrix. For example, the
last time I received this error I had just finished downloading and installing the new Access
Conversion Toolkit on my Windows 2000 PC at work (I have local admin. privledge):

http://www.microsoft.com/downloads/...76-5D89-450A-B977-980A9841111E&displaylang=en

Here is a copy of a message I posted on Aug. 8th (Re: Is it really true this is not supported in
Windows 2000)
From: Tom Wickerath

Newsgroups: microsoft.public.access

Sent: Sunday, August 08, 2004 10:35 PM

Subject: Re: Is it really true this is not supported in Windows 2000

I have tested it on Windows 2000 Professional (at work) and Windows 2000 Server (at home). It
worked okay with both operating systems. However, I had an initial error on my Win 2000 PC at
work, when I attempted to click on "Add to search list". I received an error that read: "Object
variable or With block variable not set". I think this was just an example of how VBA code can
sometimes act like a temperamental child. I seemed to be able to solve the problem by
recompiling the code behind the form. I was surprised to notice that whoever wrote the VBA code
didn't bother to use Option Explicit. If you add this line of code, you immediately have at
least one undeclared variable to deal with.

Part of the huge download involves the Conversion Tool documentation, complete with narration,
which I think is more than most developer's are interested in wanting or needing to listen to.
Also, strangely enough--as far as I can tell--the E-Briefings for "Sales Support" and "Management
Support" are identical, with the exception of the narrator. The Sales Support tutorial is
narrated by a male voice; the Management Support tutorial is narrated by a female voice. Both
tutorials appear to be word-for-word identical! So, part of this huge download seems to involve
a redundant copy of an E-briefing.

Tom



_____________________________________


We have several clients who are working with our Access application in a
Citrix environment. One of them after interting some records recieves the
message "Object variable or with block not set". After that all the fields
in the form show the value "#name?". Does anybody have any idea? All other
clients (including Citrix users) have no problem.
 
F

fttp

Frits van Soldt said:
We have several clients who are working with our Access application in a
Citrix environment. One of them after interting some records recieves the
message "Object variable or with block not set". After that all the fields
in the form show the value "#name?". Does anybody have any idea? All other
clients (including Citrix users) have no problem.
Click to expand...
 
T

Tony Toews

Arvin Meyer said:
If you haven't done so already, split the database into front-end (code,
queries, forms, etc.) and back-end (data tables). Make a folder on the
Citrix server for each user, and put a copy of the front-end in it.
Click to expand...

Or use the Auto FE Updater. 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.

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
 
F

Frits van Soldt

Arvin Meyer said:
If you haven't done so already, split the database into front-end (code,
queries, forms, etc.) and back-end (data tables). Make a folder on the
Citrix server for each user, and put a copy of the front-end in it.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
Click to expand...
Thamk you (and others) for answering! We have a seperate front- and backend
like you advise. I am not sure if every user has his/her own front end, I
will look into that. But at the moment there is only one user using the
Citrix version of the application.
 
Top