Q. I delete from table, and the query still shows the record !

  • Thread starter Thread starter Jim Jones
  • Start date Start date
J

Jim Jones

Hi,

Why is it that on a query based on two of my tables, certain records
show up, even when I manually delete them from the underlying table
(the many side).

So, I deleted them from the tables (in my split database), and then go
back into the front-end, run the query, and the deleted records still
show up.

Even after I've closed both databases, and go back in.
I've never seen this.

Where/why does the query save this data ?

I've not yet created the new form I want to use as a look-up form,
based on this query.

Thanks,
Jim
 
Jim Jones said:
Hi,

Why is it that on a query based on two of my tables, certain records
show up, even when I manually delete them from the underlying table
(the many side).

So, I deleted them from the tables (in my split database), and then go
back into the front-end, run the query, and the deleted records still
show up.

Even after I've closed both databases, and go back in.
I've never seen this.

Where/why does the query save this data ?

I've not yet created the new form I want to use as a look-up form,
based on this query.
Click to expand...

Either your query is not using the table you "think" it is or you deleted
the wrong records. Queries are simply views of your table data. They
cannot produce records out of thin air.
 
Either your query is not using the table you "think" it is or you deleted
the wrong records. Queries are simply views of your table data. They
cannot produce records out of thin air.
Click to expand...

OK,

I got the records deleted, but I thought I could do it from the query.
The query certainly lets me enter records (via form).

Please enlighten,
Jim
 
Jim Jones said:
On Tue, 16 Mar 2004 09:06:24 -0600, "Rick Brandt"

OK,

I got the records deleted, but I thought I could do it from the query.
The query certainly lets me enter records (via form).

Please enlighten,
Click to expand...

I don't think I've ever seen a query that would let me add records, but not
delete them. Do you get an error message?
 
Jim
I had the same problem a while back, and was able to determine that problem came from the recordset type of the query being Dynaset (Inconsistent Updates). When I changed this to Dynaset, the problem went away.

----- Jim Jones wrote: ----

Hi

Why is it that on a query based on two of my tables, certain record
show up, even when I manually delete them from the underlying tabl
(the many side)

So, I deleted them from the tables (in my split database), and then g
back into the front-end, run the query, and the deleted records stil
show up

Even after I've closed both databases, and go back in
I've never seen this

Where/why does the query save this data ?

I've not yet created the new form I want to use as a look-up form
based on this query

Thanks
Ji
 
Jim-
I had the same problem a while back, and was able to determine that problem came from the recordset type of the query being Dynaset (Inconsistent Updates). When I changed this to Dynaset, the problem went away.
Click to expand...

Thanks, and I think that may explain some other things. I will give it
a try.

Jim
 
Back
Top