Access 2003 Connection String

[Tallboy]

Hi Folks,

Can anyone provide a reliable ( and Simple) connection string (DSN Less) that will work with MS Access 2003 to connect ot SQL Server 2008.

With a simple T-SQL Statement either updating a TblCLients or receiving a recordset

kind regards

 

[bparkinson]

http://www.connectionstrings.com/sql-server-2008

http://msdn.microsoft.com/en-us/library/ms177523.aspx

Bear in mind if you are using SQL Server, the best way to update a record is through a stored procedure, IMO. That way the database work happens in the database engine.

 

[Tallboy]

Got my ADO string working so feel I have climbed a mountain.

Thanks for the help.

Still not clear on the main difference between DAO and ADO ! both seem to do the same thing