Temporary QueryDefs

A

Andrew

I have a query that is dynamically generating, thus I am
using a temporary QueryDef. However, after I open up the
recordset, I need to edit it. Is it possible to set a
recordset with a temporary QueryDef as editable, or any
way to circumvent the read-only limitations of temporary
QueryDefs?

Thanks,
Andrew
 
W

Wayne Morgan

Here is an example from the help file for DAO.

Set rstTemp = dbsNorthwind.OpenRecordset( _
"SELECT * FROM Employees", dbOpenDynaset)

Provided the query is one that would be editable to begin with, this should work. You may
want to make a stored query out of your temporary query just to test and see if it will
work. Once you make the stored query, go to the query window and open the query and see if
you can make changes. If not, then there is a problem with the query.
 

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

Is it possible to access a temporary query from a second query? 8
Temporary Pass-through Query as Rowsource for Listbox? 4
Set Querydef SQL to Null (Open an empty query editor) 21
Creating subroutine with Function using sql recordsets 1
sql statement return single value 1
Requery of DAO Recordset Fails on Third SQL String 2
Working with the querydef object issues... 2
Display Yes/No instead of -1, 0 on Search Forms 1

Top