W
Waldi
I'm trying to export the result of a query to a CSV file, and got the following message : "The Microsoft Jet engine cannot open the file. It is already opened exclusively by another user, or you need permission to view its data."
I discovered that it only happens when I have fields as "Expr1: Null" in my query (this is to export Null columns). This works fine in other databases I have. I resolved this problem by changing the query to "Expr1 : "" " (i.e. double quotes). This allowed the export to work.
I suspect this may have something to do with the version of Access it was created in. The one I had a problem with was created by a different user (but that is not the problem, since I imported all the objects into a database of my own).
I discovered that it only happens when I have fields as "Expr1: Null" in my query (this is to export Null columns). This works fine in other databases I have. I resolved this problem by changing the query to "Expr1 : "" " (i.e. double quotes). This allowed the export to work.
I suspect this may have something to do with the version of Access it was created in. The one I had a problem with was created by a different user (but that is not the problem, since I imported all the objects into a database of my own).