By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,490 Members | 1,280 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,490 IT Pros & Developers. It's quick & easy.

Silmultaneous instances of MS Access 2K

P: n/a
I'm wondering how many different users on different workstations can
open the same ade file residing on a server. Is there a limit and how
would I trap any errors?
Thanks
lq
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On 5 Apr 2004 15:52:39 -0700, la*************@hotmail.com (Lauren
Quantrell) wrote:

254.
Note that the preferred configuration is with the ade on each
workstation.

-Tom.
I'm wondering how many different users on different workstations can
open the same ade file residing on a server. Is there a limit and how
would I trap any errors?
Thanks
lq


Nov 12 '05 #2

P: n/a
> open the same ade file residing on a server. Is there a limit and how

I don't think so (it's not like an mde or adp), but don't you get a
warning message for the second and subsequent users?

(david)

"Lauren Quantrell" <la*************@hotmail.com> wrote in message
news:47*************************@posting.google.co m...
I'm wondering how many different users on different workstations can
open the same ade file residing on a server. Is there a limit and how
would I trap any errors?
Thanks
lq

Nov 12 '05 #3

P: n/a
la*************@hotmail.com (Lauren Quantrell) wrote:
I'm wondering how many different users on different workstations can
open the same ade file residing on a server. Is there a limit and how
would I trap any errors?


I recall reading some postings that there is some kind of limit at 20 users per
ade/adp. However this isn't a good idea anyhow. The following actually works for
any kind of file Access MDE/ADE, VB .exe, etc.

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
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.