Excel Query Causes Access To Go Read-Only

[T Stephens]

When querying data from Access into Excel 2007, Access switches to read-only
mode. Is there any way to keep Access from doing this when executing the
Excel queries?

Thanks in advance!

 

[Jacob Skaria]

By default, when you set up an Excel datasource, it will be in read-only
mode. You will not be able to update any of the Excel data. If you wish to
update your data, you need to switch off the Read Only flag when you
configure the datasource. This is done by clicking on Options and
de-selecting Read Only.

If this post helps click Yes

 

[T Stephens]

Thanks for your response. However, in this case the datasource is Access. So
the question is how do I query data from Access into Excel without Access
going into read-only mode.