Good morning all,

A quick question regarding data sharing between Access and Excel. I have an Access Database and an Excel Sheet that imports data from Access (via Data > Import External Data).

The problem I have encountered is that if the Excel sheet is open, access to the Database becomes read-only. I believe there is a way, either in Access or Excel to prevent this and allow the data to be "shared" in real-time.

I have not, however, been able to locate anything on-line that would allow me to do this.

Does anyone know if this is possible, or am I barking up the wrong tree?