Connection of Excel 07 pivot table to Access Query makes DB read o

C

Chuck W

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Active Content in this file is blocked issue 1
Embedded Excel into Word with Tables 0
Excel 2010 (64 bit) External Data connection with Access 0
Embed the same Excel multiple times 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Slicers and Calculated Items in Pivot Table 2
Connection files and pivot tables 0
2007 Pivot Tbl to Access Conversion Issues 4

Top