Allow Multiple Users of a MDE

[winty03]

Good Morning, I was wondering how I could set up a .mde to be used by
multiple users? How I have things set up are....I have the .mdb split
and into a .mde I have the Front End .mde on a shared region folder on
the network. Everyone in the region uses this folder to share files.
Is there a way to allow that .mde file to be opened by multiple users?
I don't have the option of of pulling the FE to each workstation,
because there are users in many cities using this file. Any
suggestions? Thanks

 

[Rick Brandt]

Good Morning, I was wondering how I could set up a .mde to be used by
multiple users? How I have things set up are....I have the .mdb split
and into a .mde I have the Front End .mde on a shared region folder
on the network. Everyone in the region uses this folder to share
files. Is there a way to allow that .mde file to be opened by
multiple users? I don't have the option of of pulling the FE to each
workstation, because there are users in many cities using this file.
Any suggestions? Thanks

Multiple cities? So you are trying to run an Access file over a WAN? That
is a recipe for disaster. Access generates too much network traffic to be
run over anything slower than a full-blown LAN connection.

You "Can" allow mulitple users to open the same MDE but it is slower and
leads to frequent corruptions of the file. That corruption risk is
increased by guess what? A less than perfect network connection. Trying
this over a WAN is virtually guaranteed to be a complete disaster.

 

[Albert D. Kallal]

First, I explain "why" you need to split you database.

While you seem reluctant to do this, can't reliably run the system
otherwise....

So, you can read the "why" you need to split here: (I do more then just
"tell" you, but when you walk away from reading this article, you will have
a better understanding as to why you need to do this....

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm


You also mentioned different cites, and that suggests that you are planning
to use a wan in place of LAN....

I explain once again why a high speed T1 line is far to slow, and again is
not going to work here:

http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html

 

[Tony Toews]

Good Morning, I was wondering how I could set up a .mde to be used by
multiple users? How I have things set up are....I have the .mdb split
and into a .mde I have the Front End .mde on a shared region folder on
the network. Everyone in the region uses this folder to share files.
Is there a way to allow that .mde file to be opened by multiple users?
I don't have the option of of pulling the FE to each workstation,
because there are users in many cities using this file.

You already have some comments on the issues of running Access over a
WAN as being troublesome.

What you could do though is give each user their own copy in a folder
named by user on the server. While this won't be as efficient as
having the FE on the individual computer this approach did work for
one client on a Citrix Server system.

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