| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Connection of Excel 07 pivot table to Access Query makes DB read o
Hi,
I created pivot tables in Excel 2007 based on Access queries. The problem is that when I open the Access database, the database is read only. If I close my Excel file, then the database is fine - not read only. Is there a setting change in Excel which would allow me to open the Access DB while the Excel file is open and it not be read only? I checked the Connection Properties but could not find the setting. Thanks, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Access query not showing as sources for pivot table | Excel Discussion (Misc queries) | |||
| Query from Access into Excel cause Access to go to read only | Excel Discussion (Misc queries) | |||
| Finding the Access query a pivot table is based on | Excel Discussion (Misc queries) | |||
| Excel Pivot Table or Access Cross Tab Query Question | Excel Discussion (Misc queries) | |||
| Linking parameter query from Access to pivot table in Excel | Excel Discussion (Misc queries) | |||
![Chuck W[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
