Sharing Access *.mde file

Re: Sharing Access *.mde file

Each user should have a copy of the front-end .MDE file (queries, forms,
reports, macros, and modules) linked to tables in the .MDB back end in the
shared folder. .MDE "compiles" the code, and locks out design view of
objects that can have a module. It is not necessary for, nor does it enhance
the capabilities of, multiuser operation, except for a
probably-barely-discernable speed improvement.

If the database is not open when the user is blocked because "... exclusive
use", then there is a possibility that an .LDB file is not being deleted
when the last user exits. Each user must have full permissions on the
share -- read, write, create, and delete. It is also possible that when the
user whose entry is causing the message logged in, it _was_ for exclusive
use.

A somewhat old, but still applicable, presentation on Access in the
Multiuser Environment can be downloaded from
http://appdevissues.tripod.com/downloads.htm. It will, at least, indicate
topics I thought worth discussing.

The best resource for multiuser applications, especially regarding
performance and avoiding corruption, is MVP Tony Toews' site at
http://www.granite.ab.ca/accsmstr.htm. It is certainly worth your time to
visit and take a look.

Larry Linson
Microsoft Access MVP


"jy" <UseLinkToEmail @dbForumz.com> wrote in message
news:4_729772_4 34fea1248cd83c3 bca41c843834a4e 5@dbforumz.com. ..[color=blue]
> I have converted my Access database into *.mde format. However, my
> colleague can't seem to open the file. The message shows that another
> user has opened it in exclusive mode. However, the file is actually
> not open at that time.
>
> We are connected by server, so she accesses the file through a shared
> folder located on my PC. I have not set any other security features
> other than locking my VBA code with a password. Is there any reason
> that she can't open the file? Does the file need to be copied to her
> PC, meaning that we can't share the file through a shared folder?
>
> --
> Posted using the http://www.dbforumz.com interface, at author's request
> Articles individually checked for conformance to usenet standards
> Topic URL:[/color]
http://www.dbforumz.com/MS-Access-Sh...ict213263.html[color=blue]
> Visit Topic URL to contact author (reg. req'd). Report abuse:[/color]