I have an Access front-end to SQL Server back-end.
Additionally there is an ODBC link to our accounts package, Sage.
When I open the database by double-clicking the icon, it all works fine.
However, I get the database to open automatically from a procedure in Excel to make it easier for the users. When this happens the ODBC link to Sage fails.
Does anyone have any ideas why opening the database from code breaks the link to Sage?