So I am running SQL 2000 DB, I created some views for the users here and linked those views to access. This is the scenario:
Open the Access DB already setup and using the views from SQL
File -> Get External Data ->Link Tables (Also tried Import but same thing happens)
I select ODBC Databases from the bottom of the list and poof, the selection window disappears but nothing happens.
Tried a system restore but that's a joke, none of my restore points work
Uninstalled some of the stuff I have installed since this was working last, then uninstalled MS Office and reinstalled everything.
Running XP pro, MS Office 2003. The Access DB file is stored on the network.
Thanks in advance for any help/advice