I am upgrading my database from access to sql 2000 server. In access I was able to link and update my tables via an odbc datasource, therefore when i made changes to my tables in access the change was reflected when viewing the file in thoroughbred basic. Im sure this is easy to do and I am just not understanding the concept however I still need help. I would like to be able to edit my obdc data sources in sql server 2000. Please help, ive been trying with sp_addlinkedserver but have so far been unsuccessful.

Thanks
Evan