"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 ?
> >
>

"TJS" <nospam@here.com> wrote in message
news:10dm523btum1rd5@corp.supernews.com...
> 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 ?
> > >
> >
>
>

"Stephen Dybing [MSFT]" <stephd@online.microsoft.com> wrote in message
news:OBa0OViWEHA.2844@TK2MSFTNGP11.phx.gbl...
> MSDE is not a development platform, it's a deployment platform. I would
> suggest that you spend the <$50 required to purchase SQL Server Developer
> Edition. It contains everything you'll need to develop for the SQL Server
> and MSDE platforms (really the same thing).
>
> I'll even go out on a limb and predict that Mary will say the same thing.
> :-)
>
> Yes, you can use Access as a front end to MSDE, but you'll likely find the
> tools she mentioned easier to use to create and manage your database.
>
> --
> Sincerely,
> Stephen Dybing
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "TJS" <nospam@here.com> wrote in message
> news:10dm523btum1rd5@corp.supernews.com...
> > 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 ?
> > > >
> > >
> >
> >
>
>