Access07 make-table problem

P

Pendragon

I have a client using Access 07. From code, I am running the following:

docmd.setwarnings false
docmd.openquery "qryGetCurrentIDs"
....other queries...
docmd.setwarnings true

On the first OpenQuery item, I am getting an Error 3010 telling me the Temp
table I am using in the make-table query already exists, and then quits.
This is not a prompt to overwrite. If I try to run the query directly, I get
the same error.

This was not a problem up until a couple of weeks ago. Is this a new issue
or am I missing something in Access 07?

Thanks.
 

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

React JS Outlook Add-in - VS Code + WebPack - Unable to call external Web Service - CORS Issue 0
Outlook Add-in - Javascript based using React JS - VS Code + WebPack - Unable to call external Web Service 0
Using variables as table names in an append sql statemnt 1
Make Table Query with path Parameter 1
running a "make table" query using VBA 3
Set Warnings false is misbehaving 3
Make table query: [Enter 1] AS Test 1
#error - Blank 3

Top