Best way to link Access to SQL Server

		Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
Best way to link Access to SQL Server

Access VBA Discuss using VBA for Access programming.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

May 31st, 2006, 04:28 PM

echovue

Friend of Wrox

Join Date: Oct 2004

Posts: 564

Thanks: 0

Thanked 4 Times in 4 Posts

Best way to link Access to SQL Server

I am sure there is a definitive answer somewhere. What I need to do is link an Access 2003 app to a back SQL Server Database. Is a ODBC/DSN connection the best way to do this, or is there a better way?

Thanks in advance,

Mike

Mike
EchoVue.com

__________________
Mike
EchoVue.com

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SQL SERVER link problem.please hope me.	kukusheng	Classic ASP Databases	0	July 29th, 2007 08:26 PM
Raise an Error in dynamic SQL with Link Server	bashiiui	SQL Server 2000	7	May 2nd, 2007 04:10 AM
can to link a ms access table to sql server?	sugar	SQL Server 2000	6	May 23rd, 2006 11:45 AM
ODBC link to SQL database from Access	mlwallin	SQL Server 2000	2	January 24th, 2005 05:30 PM
how can i link to sql-server with ado.net[B)]	zjxgjp	ADO.NET	1	December 25th, 2004 09:50 AM