Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
| Search | Today's Posts | Mark Forums Read
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
  #1 (permalink)  
Old May 31st, 2006, 04:28 PM
Friend of Wrox
 
Join Date: Oct 2004
Location: Clinton, UT, USA.
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
Default 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





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.