| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Query Causes Access To Go Read-Only
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Query Causes Access To Go Read-Only
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 --------------- Jacob Skaria "T Stephens" wrote: 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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Query Causes Access To Go Read-Only
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. "Jacob Skaria" wrote: 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 --------------- Jacob Skaria "T Stephens" wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Connection of Excel 07 pivot table to Access Query makes DB read o | Excel Discussion (Misc queries) | |||
| Query from Access into Excel cause Access to go to read only | Excel Discussion (Misc queries) | |||
| Can I use MS Query in Excel like an Append Query in Access | Excel Discussion (Misc queries) | |||
| Run Access query from Excel, input value to query being value in c | Excel Programming | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
![T Stephens[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
