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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Peter Davies - 23 Dec 2003 08:46 GMT

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

Reply to this Message

Andy Williams - 23 Dec 2003 13:25 GMT

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

> An ACCESS 2000 project is connected to SQL Server 2000
> database.
[quoted text clipped - 12 lines]
>
> Peter

Reply to this Message

Van T. Dinh - 23 Dec 2003 14:39 GMT

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.

Signature

HTH
Van T. Dinh
MVP (Access)

> 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
[quoted text clipped - 4 lines]
>
> -Andy

Reply to this Message

Kevin3NF - 23 Dec 2003 15:08 GMT

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.

Signature

Kevin3NF

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

> AFAIK, all MS-SQL Server databases are opened "shared" and never
> exclusively. Hence, it follows that the ADP connection cannot exclusively
[quoted text clipped - 8 lines]
> >
> > -Andy

Reply to this Message

- 24 Dec 2003 08:29 GMT

Hi

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

Regards

Peter Davies

>-----Original Message-----
>An ACCESS 2000 project is connected to SQL Server 2000
[quoted text clipped - 15 lines]
>
>.

Reply to this Message