Re: adp connection to msde and exclusive rights

From: TJS (nospam_at_here.com)
Date: 06/24/04 

Date: Thu, 24 Jun 2004 10:49:33 -0700

Hi Mary:

Thanks for replying (I have your book, Developer's guide to SQL Server).

Unfortunately, I don't have the Query Analyzer or Enterprise Manager , so I
was hoping to use access as a front end.

is there any way access can be a front end to msde ?

"Mary Chipman" <mchip@online.microsoft.com> wrote in message
news:n74md01glum1t5l2c79ak6sjmj11sct03m@4ax.com...
> 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: 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)
  • Re: Cannot connect to Query Analyzer
    ... A few things to check on the issue with Query Analyzer: ... Find the file on your PC named SQL Server Enterprise ... In terms of the startup account, ... Enterprise Manager, ...
    (microsoft.public.sqlserver.connect)
  • .. Enterprise Manager and Query Analyzer?
    ... I almost feel as if I'm missing something in your question, ... Enterprise Manager and Query Analyzer? ... They are bundled with SQL Server. ...
    (microsoft.public.sqlserver.tools)
Loading