Query not updated when table updated

A

Alex Cowell

I am accessing data in an Access 2000 database from an application
using the OLE DB Provider for Microsoft Jet. The database consists of
tables and queries. When new records are successfully inserted into a
table, selecting data from the queries using SQL does not return the
live data. It appears Access queries do not update automatically.

Is this the case? If so, how can live data be selected via the query?

Thanks
Alex
 
J

Jeff Boyce

Alex

From your description, it sounds like the query has a "WHERE" expression
that is filtering out the new "successfully inserted" rows. Post your SQL
to help us better understand...

Jeff Boyce
<Access MVP>
 
A

Alex Cowell

Jeff

That was my first thought but if I alter the SQL statement to select
records from the table directly instead of from the query then the
problem disappears.

The query (qry_sizes_available) syntax is:
SELECT * FROM tbl_sizes WHERE sze_unavailable=0;

The following statement is not returning newly inserted records:
SELECT * FROM qry_sizes_available

But if if the first SQL statement is executed directly on tbl_sizes
then it returns newly inserted records as expected.

Alex
 
J

Jeff Boyce

Alex

Nothing comes to mind, aside from the possibility of some subtle corruption
in the query. What happens if you start from scratch, creating a totally
new query (new name)?

You also might try searching Google.com under computers, databases, msaccess
group for previously posted Q&A.

Good luck

Jeff Boyce
<Access MVP>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top