Jet Database Engine cannot open the file...

1

1978fx

I'm trying to EXPORT the results of a query to a CSV file. I've been
doing this, using different queries, for WEEKS, with no problems. This
file always thinks that the resulting export file is already opened,
but the file resides on my hard drive, and I get the error even if I
delete the file and start from scratch.

I'm not doing this via programming; just FILE > EXPORT.

The errors are:
"Microsoft Jet Database Engine cannot open the file...It is already
opened exclusively by another use, or you need permission..."
"An error occurred trying to export data from table...The data was not
exported."

If I replace all the "NULL AS..." fields in my query with
"" as...
the export works. HOWEVER, I have about 10 other queries that do this,
with "Null as..." and work just fine.

Any ideas?

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

Solved Disk Full error message when exporting PDF 0
Active Content in this file is blocked issue 1
Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine) 0
Microsoft Jet database engine could not find the object 4
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
jet database engine error 1
Outlook 2010 can't find .pst file 1
Jet Engine cannot open the file 0

Top