Database Link to SQL Server 2000 database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to create a database link for Access 2000 to a SQL Server 2000 database. Would someone get me started in the right direction.......Thanks, marty
 
marty said:
I need to create a database link for Access 2000 to a SQL Server 2000
Click to expand...
database. Would someone get me started in the right direction.......Thanks,
marty

That's a lot of answer for a small question.

I would heartily recommend "MS Access Developer's Guide to SQL Server" by
Mary Chipman and Andy Baron. ISBN: 0-672-31944-7

I had to convert a sizable db to SQL Server 2000 and found it invaluable.

I would also strongly recommend that you update your Office 2000 to the
latest patches and service packs as Access support for ADP / SQL Server 2000
is seriously broken without them.

Hope this helps.

Chris Strug
 
Then you will need to create a DSN on your system pointing to the correct
SQL Server database. Once done, link the tables from File>>Get External
Data>>Link Tables. In the dialog box, select ODBC dataa sources and choose
the DSN you just created.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
 
Back
Top