Database Link to SQL Server 2000 database

[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

 

[Kevin3NF]

Access Project (ADP) or regular database (MDB)?

--
Kevin Hill
President
3NF Consulting

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

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

 

[Chris Strug]

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

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

 

[Guest]

regular MDB

 

[Kevin3NF]

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