ADP multiuser deployment

[Riz]

Hi

I have recently upsized an MDB to an ADP and am ready to depoly it on my
network.

A problem I have encountered is that when I try to open more than one
concurrent ADP, the application does not let me. I understand from articles I
have read that you can not use the same front end application like you can
with an MDB, so I created copies of the ADP on the user's desktops but still
no joy - I just can't seem to get more than one instance of the ADP working
with my SQL backend. I'm stuck and wondering what I to do now?

All help is much appreciated.

Kind regards,

Riz

 

[Sylvain Lafontaine]

Two possible explanations:

1- you have made a copy of the shortcut instead of the ADP file.

2- or you have added some piece of code running at the startup of your
file that specifically excludes a second connection in some way or other.

 

[Robert Morley]

Similar to Sylvain's suggestion #2, make sure that your SQL Server database
isn't in one of the Restricted Access modes. To do that, right-click on
your SQL database from the SQL Server Enterprise Manager, then click
Properties and look at the Options tab. Make sure both "Restrict access"
and "Read-only" are turned off.



Rob