Attempting to link crappy ass and outdated access db as a linked server in SQL, but it keeps failing. has anyone done this successfully? IT shows up in the linked servers list, but I get an error when attempting to open the "tables" on the tree Error is 7303 - could not initialize data source. Here is my code:
USE Master GO EXEC sp_addlinkedserver 'HR_ACCESS_CRAP', 'OLD DB Provider for Jet', 'Microsoft.Jet.OLEDB.4.0', '\\aka1\anthchr\internet_applications\hr_internet_applications.mdb' GO Thanks in advance for any help. --Beth, Pseudo usenet cop Merlin MTB, BikeE AT, RANS gliss, Trek R200, Kickbike Owned by Kavik (Samoyed Boy) Anchorage, Alaska ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
