I have a general question regarding Access ADE files. I've recently adopted
some Access applications and have questions regarding multi-user behavior.
I've noticed on the MDE application that multiple users can be in the same
file located on the file-server at the same time and no read-only errors
occur(on opening). I've recently created an Access ADP and moved the same
access tables into SQL-Server. I've created an ADE file with no problem;
however, when I try and use the ADE file multiple times (same file location)
I get a read-only error once the second user opens the ADE file. I've
observed MS has a deployment toolkit for building packages to distribute
ADEs.
1. Must each client have their own version of the ADE on their client
machine to avoid the "read-only" error? or is there a way to allow multiple
users to use one file? ( I understand this may not be a best practice).
2. I understand the fundamental difference between the ADP-MDB/ADE-MDE, I
assumed MDEs and ADEs would behave similarly ( I know what they say about
ASSumptions), why are they different? (If you know the meaning of life you
can tell me that too!)
Thank you
Rick F
Alex Dybenko - 11 Apr 2006 09:33 GMT
Hi,
> 1. Must each client have their own version of the ADE on their client
> machine to avoid the "read-only" error?
yes. also to avoid additional network

Signature
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com
Rick F - 11 Apr 2006 13:25 GMT
Thanks Alex for the info.
> Hi,
>
> > 1. Must each client have their own version of the ADE on their client
> > machine to avoid the "read-only" error?
>
> yes. also to avoid additional network
Pat Hartman(MVP) - 15 Apr 2006 05:04 GMT
Jet is what provides the security and file sharing capability for Access
.mdb and .mde databases. I don't believe that the .adp/ .ade use Jet at
all. When an .mdb/.mde is opened, Jet creates an .ldb that it uses to track
who's doing what to what. Without the .ldb, there is no way to secure/share
the app.
Most people don't realize it because it is hidden so smoothly but ALL
.mdb/.mde's are secured. They are secured by the default workgroup file
which is always named system.mdw and by the default user which is Admin.
Without Jet to control file sharing, it is not possible to share .adp/.ade's
>I have a general question regarding Access ADE files. I've recently
>adopted
[quoted text clipped - 23 lines]
>
> Rick F