Close Connection to Access

[Minder]

Hi all,

I need help for a real difficult problem. In my Excel sheet I get Data via macro from an Access File. Sometimes a query is the source and sometimes a table. Everything is working fine.

The Problem is, as long as I have opened the Excel File, I can't edit the Access Database (read-only). If I want to make changes in the Access file, I have to close the Excel File, since that means closing the connection to Excel.

The question is: How can I close the connection to Excel with VBA without closing the complete Excel file? Reason being is that other people can work with the Access File while the Excel File is still open.

Can someone help?


BTW:

That's how the code which retrieves the data from Access looks like:

Please Login or Register  to view this content.

[teshiburu1988]

Minder,

Try adding

Please Login or Register  to view this content.

i think this will prevent you from having to even close the connection as your connection via excel will be come read only

Teshi...

[Minder]

Alright. Sorry about that.

[Minder]

Thanks Teshi. Actually it did not sound bad. Unfortunately it does not work. I added

Please Login or Register  to view this content.

to my code.
The Query is running fine but I still get read only to my Access File while the Excel File is opened.

This problem drives me crazy

[Minder]

I found the solution.

The code from the macro recorder included

Please Login or Register  to view this content.

After deleting that part I can write in my Access Database while Excel is open