Exclusive Connection....Access 2000 ADP and SQL Server

  • Thread starter Thread starter Peter Davies
  • Start date Start date
P

Peter Davies

An ACCESS 2000 project is connected to SQL Server 2000
database.

When I open the "Data Links Properties" dialouge box and
click on the Advanced Tab, the "Access Permissions" has
been disabled. Hence I am unable to exclusively open the
SQL Server Database.

The database has been opened with NT authentication and
this user is status "dbo".

SO over to you ladies and gentlemen.

Regards

Peter
 
Someone else may care to elaborate, but I believe these settings do not
apply or are not supported by the OLE DB provider for SQL Server which ADP
uses. However, they do apply to the provider for ODBC and the Jet 4
provider.

Not sure why though....

-Andy
 
AFAIK, all MS-SQL Server databases are opened "shared" and never
exclusively. Hence, it follows that the ADP connection cannot exclusively
lock the MS-SQL database.
 
Hi

Many thanks for everybody's input I know what to do with
my project now.

Regards

Peter Davies
 
Back
Top