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

Sharing Access *.mde file

P: n/a
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?

--
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-Sh...ict213263.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=729772
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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" <Us************@dbForumz.com> wrote in message
news:4_***************************************@dbf orumz.com...
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-Sh...ict213263.html Visit Topic URL to contact author (reg. req'd). Report abuse:

http://www.dbforumz.com/eform.php?p=729772
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.