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

[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

 

[Andy Williams]

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

 

[Van T. Dinh]

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.

 

[Kevin3NF]

You are correct. There are ways to lock a SQL Server down (single-user
mode, deny permissions, etc.), but that's is not what SQL Server was
intended to do.

--
Kevin3NF

Sick of all that junk filling up your mailbox?
http://spamarrest.com/affl?2967001

 

[Guest]

Hi

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

Regards

Peter Davies