Re: create views from access project

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 06/18/04 

Date: Fri, 18 Jun 2004 10:59:56 +0200

This is an Access problem, and you will probably be better helped posting this in an access forum. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"TJS" <nospam@here.com> wrote in message news:uUrXRYOVEHA.2920@TK2MSFTNGP10.phx.gbl...
> 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 errorwhen 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: 64bit insert delays
    ... Tibor Karaszi, SQL Server MVP ... > we/users can query when mails were processed by the antispam system, ... this sounds like you are selecting from some other table than the one inserting into and you ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Truncating Log Files
    ... Tibor Karaszi, SQL Server MVP ... I have ran dbcc loginfoand used found that I have about 136 Gig at ... my LSN for Log Shipping and possibly break my Mirroring? ...
    (microsoft.public.sqlserver.server)
  • Re: Subquerie in CHECK Constrain
    ... I recall once retrieving a record set in VB, looping it and for each row, executing another ... Tibor Karaszi, SQL Server MVP ... >> Kalen Delaney ... >>> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: errr........getdate within a function.
    ... Tibor Karaszi, SQL Server MVP ... "Jacco Schalkwijk" wrote in message ... >> CREATE FUNCTION foo1RETURNS datetime AS ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Maintenance did not delete old files
    ... The last thing I'd triple check is the configuration regarding recurs subfolders, ... Tibor Karaszi, SQL Server MVP ... Yes, I did the maintenance plan in a well design, the same maintenance plan on another PC running well on developer edition but not on standard edition. ...
    (microsoft.public.sqlserver.server)