Database Link to SQL Server 2000 database

M

marty

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
 
C

Chris Strug

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
 
K

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Naming of Form Button 3
Help creating a search form in Access XP 0
Data provider could not be initialized 1
Delete 100 Hundred Unique Values From Word Document 0
Using Access Database to build contracts with fields on pdf document 0
Creating a Search using a combo box and then creating a report. 4
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
VBA Export to PDF 0

Top