Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Multiuser / Networking / April 2006

Tip: Looking for answers? Try searching our database.

Characteristics of ADE

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rick F - 10 Apr 2006 20:16 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.