Re: DELETE query error message

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

From: HeatherD25 (HeatherD25_at_discussions.microsoft.com)
Date: 10/21/04 

Date: Thu, 21 Oct 2004 06:29:01 -0700

The command button to delete the entry is on the form called "Project Master
- TEST". The data that is displayed on this form comes from the table
"Project Master". Does that help?

"Ken Snell [MVP]" wrote:

> Is the form that you're using bound to the table Project Master? Or to a
> query that is using Project Master as a source table?
>
> --
>
> Ken Snell
> <MS ACCESS MVP>
>
> "HeatherD25" <HeatherD25@discussions.microsoft.com> wrote in message
> news:3806DD2C-4132-4BA7-95E2-C9FC7965A574@microsoft.com...
> > Hi,
> >
> > I am trying to perform a delete query from a form. I created a button
> that
> > invokes the query. When I perform the action I get the message that says
> > "The table 'Project Master' is already opened exclusively by another user,
> or
> > it is already open through the user interface and cannot be manipulated
> > programmatically." and it won't let me delete.
> >
> > Here's my SQL for the delete:
> > DELETE [Project Master].*, [WS-A Scoring-BP].*, [Project Master].[Project
> > Number], [WS-A Scoring-BP].[Project Number], *
> > FROM [Project Master] INNER JOIN [WS-A Scoring-BP] ON [Project
> > Master].[Project Number] = [WS-A Scoring-BP].[Project Number]
> > WHERE ((([Project Master].[Project Number])=[Forms]![Project
> > Master]![Project Number]) AND (([WS-A Scoring-BP].[Project
> > Number])=[Forms]![Project Master]![Project Number]));
> >
> > Also, I'm working on this database after someone else created most of it.
> > Is there a setting that maybe they turned on that loks up the tables when
> a
> > form is open?
> >
> > Thanks!!!
> >
> > Heather
> >
>
>
>

Quantcast