Query not updated when table updated

  • Thread starter Thread starter Alex Cowell
  • Start date Start date
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
 
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>
 
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
 
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>
 
Back
Top