Search results

I found a workaround, it is really old school. I use a SQL statement and just DROP VIEW and ignore the error if the view could not be found. It does not use ADOX or DoCmd at all. I guess it helped for me to type out the problem though.

Hello Banana or anyone reading this, This is just on the off chance as I can see this thread is 10 years old, but I am having this exact same situation. Do you have any ideas? It seems most people get cat.views.delete to work somehow. The problem is this- The query is there. I try and delete it-...

I've followed that up using ADOX inside Excel vba to create the qryCrosstab. So the code makes and saves the query, then runs the "Select * Into newTable From qryCrosstab;" type command. It works too! Thank you arnelgp and isladogs for the part I had missed, and plog for the immediate reply. I...

I may have missed something- I though Select Into was the way to make a table.

Sorry, crossed reply. I didn't think of MAKE TABLE.

Hello Plog, thanks for replying so quickly. The thing is, the code is run from VBA inside Excel. I know how to run single SQL code executions from inside that environment, but not saving a query and incorporating that in a subsequent step. But maybe something to investigate. Thanks again. R.

Hello, There are a few posts about this, both on this and other forums. As the ones on here were the best ones I could find, I thought I would ask on here. The answer seems to be to use a make-table query (select ...into..from) with the crosstab query (transform ...) and it all works fine. I've...