Thanks, Mike.
I was following the method in a file I think you pointed me to in 2011, starting:
>>>
Manual Linking of Access 2007 Database to Recorder 6 SQL Server Database
This paper explains how to manually link an Access 2007 or 2010 database to the Recorder 6 SQL Server Database. The screenshots are based on a Windows 7 system, with an Access Windows 2010 database linked to a Recorder 6 SQL Server database in SQL Server 2008. The process for earlier versions of Access is similar, but the ODBC link is accessed via Files/Get External Data/Link tables and by choosing ODBC Databases from the list of file types.
<<<
All goes fine until #8, where the screenshot shows a drop-down. I don't have this (or rather it is empty).
My memory is that when I did this in 2011, I ran the batch file I pasted above (which I also got from you or from the site), and the file was created automatically, but although the file runs (there is a very rapid screen flicker) there is no obvious result. I have looked for linked Access files in all the likely places without success.
I hope I can solve this one, as I much prefer Access to SQL as the immediate interface for direct editing and creating queries etc. To be honest, my knowledge of low-level SQL is close to zero!
M.