Re: adp connection to msde and exclusive rights

From: Mary Chipman (mchip_at_online.microsoft.com)
Date: 06/24/04 

Date: Thu, 24 Jun 2004 10:38:08 -0700

I'd recommend not using Access as a development tool for SQL Server
objects. Use the Query Analyzer or Enterprise Manager instead. The
error message you're getting is an Access error, not a SQL Server
error.

--Mary

On Thu, 24 Jun 2004 01:08:50 -0700, "TJS" <nospam@here.com> wrote:

>I am attempting to create a View from MS Access 2000 SR-1 to an MSDE 2000
>(SQL Server 2000 Desktop Engine) database . I accessed with exclusive rights
>but I get the following error when trying to create a view:
>
>"You do not have exclusive access to the database at this time. Your design
>changes will not be saved."
>
>how can I get ability to create views ?
>

Relevant Pages

  • Re: Cannot connect to Query Analyzer
    ... For Query Analyzer, I tried replacing the file as you suggested but had the ... same results (Enterprise Manager starts up fine, ... I created an account on my laptop and changed SQL ... Try replacing the MMC app for SQL Server from the original ...
    (microsoft.public.sqlserver.connect)
  • Re: query plan in clear text
    ... Personally, I do almost all tasks from Query Analyzer, and about the only ... Enterprise Manager is to deal with jobs. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Microsoft SQL-DMO (ODBC SQLState: HY000) error when opening any ob
    ... I didn't encounter any difficulty using Query Analyzer. ... But this error message does pop up everytime I open an object in the ... database on the hosting company's server, when using SQL Enterprise Manager. ... Otherwise try asking the web host about it. ...
    (microsoft.public.sqlserver.server)
  • Re: SA can not create users
    ... If it works correctly from Query Analyzer, ... likely Enterprise Manager, but you don't say exactly what happens - is ... there an error message? ... client tools completely. ...
    (comp.databases.ms-sqlserver)
  • Re: Cannot connect to Query Analyzer
    ... On the account, Try adding the local account you created to ... For Query Analyzer, I tried replacing the file as you suggested but had the ... same results (Enterprise Manager starts up fine, ... Try replacing the MMC app for SQL Server from the original ...
    (microsoft.public.sqlserver.connect)