append queries converted to SQL:pass-through on close

M

MikeS

I've got a problem with append queries based on another
pass-through query.

I create append query qryaFillComboBox which uses the
fields returned from a pass-through query
(qrysptFillComboBoxTable).

The pass-through query calls a stored procedure on SQL
Server which simply selects all records to populate the
combo box.

The process works after I create the append query.
However, when I close and re-open the database, all of my
append queries have been converted to pass-through
queries. When that happens, I get a DAO Error #3065:
Cannot execute a select query.

Anyone have any suggestions?
 

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

Similar Threads

Displaying pass through query 1
Append Query is not working 1
Pass Through Query - not returning rows 1
Question on Pass-through Query 4
Append Query 7
Append Query and Odbc 1
Pass-Through Query Error 1
Access pass-through query to Oracle 10g stored procedure - results 1

Top