Database Connection prevents exclusive access to Database

I am using a data connection from an Access Database to populate a table in excel. The connection works great except that whenever the excel spreadsheet is open I get the following message when I try to make structural changes to the Access Database (edit a form, report, table, query, etc):

You do not have exclusive access to the database at this time. If you proceed to make changes, you may not be able to save them later.

For the purpose of my form, I only really need the database connection to refresh once when I first open Excel. Is it possible to setup the connection in a way that queries the database initially and then terminates the connection to allow exlusive access to MS Access while the worksheet is still open?

thanks!


I posted this same question on MrExcel as well but did not recieve an answer. I may not be expressing my question effectively, please feel free to ask for clarification if needed. thank you.

http://www.mrexcel.com/forum/excel-q...-database.html

I don't see a share Deny. Where would I put that? This is what the string looks like currently:

Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=O:\Bellingham\Intranet\Current Projects\Databases\Product Database\ProductDatabase.accdb;Mode=Read;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Engine Type=6;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False;Jet OLEDB:Support Complex Data=False;Jet OLEDB:Bypass UserInfo Validation=False

I'd be open to trying that. I'm not familiar with that terminology though. Could you point in the right direction to get started?

thanks!