SQL query used in Access Database

[msbi123]

I have problem selecting some of the fields using SQL Query in access database.
When I execute query in the Access SQL View it runs fine but when I take the same query to the asp page it doesn’t pool any records. It took me long time to go field by field and I finally found my problem. When I take the Auto_pkey(primary key) field out of the SQL it works fine.
How can I make this query works with the Auto_pkey primaty key for Auto table. I need to pass this field to other pages.
Please help

 

[tEkHEd]

it would help if you posted your query, as this could be due to a couple of reasons.

If you are linking your tables from a SQL (or other) Server, then you should really be creating views on the SQL server and linking the view in an Access ADP file.

I presume you are trying an UPDATE query?