The Microsoft Office Access database engine cannot open or write to the file

[fongmac]

Hopefully someone here can help me. I have an Access database file with excel macro. When I run the excel file within Access, I am getting the error "The Microsoft Office Access database engine cannot open or write to the file "name of query". It is already opened and exclusively by another user, or you need permission to view its data". I've verify that no one else has the file open. I am running Access 2010.

[June7]

Would have to analyze code. Post code or provide files for analysis. Follow instructions at bottom of my post.

[fongmac]

How do I post code?

[June7]

Copy/paste code in post editor between CODE tags, as follows (but without the space inside []).

[ CODE] code here [ /CODE]

Or attach files. The instructions are at bottom of my post. Click 'Go Advanced' button at bottom of post window.

[fongmac]

Maybe I'm explaining this wrong. I have an Access file...when I open up the Access file there is a macro setup which is trying to import two excel files. I'm not sure how to get the code. When I run compact & repair, nothing happens.

[June7]

Posting Access macro code is more difficult than posting VBA procedure. Attach screenshot or type the lines of macro into post editor. Or attach files.

[fongmac]

Here is the screenshot:



That error comes up when I run the macro in the Access file which imports two excel files. The error says it cannot write to the file "Misc"....but there is no "Misc" file. The two spreadsheets do have a "Misc" field which are both blank and does not contain any data. Apparently, this macro import use to work but all of a sudden is no longer working.

[June7]

The screenshot I suggested was for macro code, not the error message which we already knew.

If the code used to work, what has changed?

[fongmac]

How do i get the macro code?

[fongmac]

After playing around with the Access file...I went to database tools, Visual basic, and it open the VB window but still don't see where the macro code is.....

[fongmac]

if i right click on the macro and select "design view" it gives me some information. Is that the macro code?

[June7]

Yes, sounds like it. I don't use macros, only VBA, but can sometimes figure out macro. Macro can be converted to VBA procedure.

Is this a web database?

You might benefit from a review of:
http://office.microsoft.com/en-us/ac...010341717.aspx
http://www.access-vba.net/introducti...ccess-vba.html

[fongmac]

Here is the macro code converted to visual basic:

[June7]

You did not build this db? Did this code ever work?

The TransferSpreadsheet code does not reference the latest version of Excel. Parameter 5 is Microsoft Excel95 format, 9 is for Excel2007. What version of Excel files are you importing from?

Otherwise, don't see any problem with the code. So only recourse is to provide db for analysis.

[fongmac]

No I did not build this db. Yes, the code worked before. The version of excel files importing from is 2007. How do I provide db for analysis?