Access 2000 on Windows 2000 Terminal Server

[Kyle Jedrusiak]

We're having some weird problems with an Access application that I wrote.

It accesses data in another Access database and a SQL database.

About 50% of the time when doing a certain process in the application the
users gets a...

OnClick event handler error...something about the handler being invalid

It of course kills the app.

If you try the same thing 4 or 5 time on the 5th time it may work without
error.

We have all of the users running from the same .mde file.

Can someone point me in the right direction?!?!?!?

Kyle!

 

[Tony Toews]

About 50% of the time when doing a certain process in the application the
users gets a...

Is this the same process which keeps failing or a different process at
times?

OnClick event handler error...something about the handler being invalid

What's the exact message?

We have all of the users running from the same .mde file.

Not a good idea. Each user should get their own copy of the FE.

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.

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