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?
Bookmarks