Question sql server not in dropdown when linking

[dmcdivitt]

I have a windows 7 machine with Access 2000 installed. I need to link to some tables on an SQL server and "SQL Server" does not appear in the dropdown of available link types. I forgot how to fix this. I think a driver is missing. I did a clean install of Office 2000 and only selected MS Access. Maybe that prevented everything needed from being installed. I would like to add just the missing driver if possible. Thanks

 

[dmcdivitt]

I don't necessarily have to have SQL Server in the dropdown. I can link with code. But the driver is missing when I tried that. Cannot use ODBC in this case.