Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2010 (64 bit) External Data connection with Access
Windows 7 - 64 bit
Office 2010- 64 bit Prior to updating our Windows and Office to 64 bit versions, we accessed Access data from Excel using Microsoft Query. When attempting to access existing connections using Excel 2010 (64 bit), I'm prompted for a SQL Server Login and unable to access the connection. I've created a new connection to the same Access database using 'From Access' rather than through Microsoft Query (creates a connection [ConnectionName].accdb -- connections created through Query only show [ConnectionName]. This establishes a new connection and we are able to access the data in Access. However, when I have the Excel file open that has the connection, the Access database appears to be placed in a read only state and no one can modify the data. Could someone help me understand best practices for Excel/Access data connections using the 64 bit versions? Can I establish the connection and not place the Access file in a read only state? As always, help is much appreciated, Bill Carlson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External data connection needs separate login for each query | Excel Discussion (Misc queries) | |||
Excel data connection to Access | Excel Discussion (Misc queries) | |||
Problem getting external data using an existing connection | Excel Discussion (Misc queries) | |||
Excel 2007/Vista: Missing file name on import external data connection | New Users to Excel | |||
Connection to external data sources in Excel | Excel Discussion (Misc queries) |