Originally Posted by
ArviLaanemets
How do you connect the Excel workbook to Access?
I have an Access database (back-end and front-end). For testing I just opened a new Excel file, created there an ODBC query to read the main table from back-end of Access application, and got the table read into Excel. After that I leaved Excel workbook open, and opened the Access application - without any problems. Then I refreshed the query table in Excel workbook with Access application opened - again without any problems.
Btw. Are you doing some additional data entry in your Access database? When not, then you can read needed data into Excel using ODBC query directly from SQL server. When you need some calculations with read data, then you can create a view on SQL server, which presents data exactly as you need them in your Excel report, and you read the view into Excel.