Is it possible to create a linked server in SQL Server 2000 to an Access Database?
I tried to make one with following options in enterprise manager:
Server type: Other data source
Provider name: test
Product name: test
Data source: c:\db\test.mdb
Provider string...
When I set a default value in SQL Server (using Enterprise Manager), that value is not the default value in Access when I link the tables. Any suggestions?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.