I would like to bring in a table on a Linked Server on SQL Server 2000 into Microsoft Access.
The Linked Server is a MySQL table (SupervisorsTable) from a web server (a website that inserts field supervisor data). I would like to be able to update certain fields in the MySQL table on the Linked Server from an Access form.
But I can't seem to link the table SupervisorsTable on the Linked Server into Access. How can I do this?
Thank you in advance.