Temporary QueryDefs

  • Thread starter Thread starter Andrew
  • Start date Start date
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
 
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.
 
Back
Top