Sharing Access *.mde file

J

jy

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?
 
L

Larry Linson

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 said:
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: http://www.dbforumz.com/MS-Access-Sharing-mde-file-ftopict213263.html
Visit Topic URL to contact author (reg. req'd). Report abuse:
Click to expand...
http://www.dbforumz.com/eform.php?p=729772
 
Top