sharing data in ADP

[Den]

I have an access data project tied to an SQL 2000 database. Once one
person opens the ADP the next person to open it, can only do so in read only
mode. How can I set this up to allow shared access to this database. I
have set up a security group in Active Directory that allows all members
datareader AND datawriter permissions. Then made each person a member of
that security group, but that still does not allow more than one person to
open it in a shared fashion.

Any help appreciated.

Dennis

 

[Norman Yuan]

Since ADP is only front-end app of SQL Server, the second user opening the
same ADP file and getting "read-only..." prompt can still do data
manipulating designed in the ADP file. That is, "read-only..." here only
means that user cannot make changes to the ADP app's design, which is good
thing.

Do avoid this prompt, you can place the ADP file in each user's computer
(better yet, make it ADE file and place it in user computer).

 

[J. Clay]

ADPs are client server applications. Each user needs to have his/her own
copy on their workstation to open. The ADP is not designed to be shared.

 

[Den]

Thanks Norman, I appreciate the clarification.

Dennis