Is there and ODBC drive to enable an MS Access 2003 dbs under XP to link to a calc file ?
[edit: added winxp tag]
Is there and ODBC drive to enable an MS Access 2003 dbs under XP to link to a calc file ?
[edit: added winxp tag]
Goto Control Panel → Administrative Tools → Data Sources (ODBC) and register your Access database as ODBC data source.
I thought Windows XP has got all needed files. But if something is missing, look at https://msdn.microsoft.com/en-us/data/aa937730.aspx. You might need “Jet 4.0 Service Pack” and “Microsoft Data Access Components (MDAC)”.
Then register your Access database so that the .odb file is generated.