Excel link opened first only allows Read-only Access .accdb

[RemyS]

Hello

In Excel I linked External data to a query in an .accdb back-end

However whenever I open the Excel workbook first, I can then only open the access db as Read-only.

Is there any way to change this behavior so that the Excel workbook does not "steal" the exclusivity?

NOTE: I somehow used an ODC source, though don't recall how I created that ODC to the database in the first place

P.S. I've been out of the game for a while, some coming into Access 2007 as a bit of a novice

Thanks for any explanations, tips, pointers

Hundreds of ways to do things with PC's, and learning new ways every day.