[AccessD] Get an updateable ADODB recordset form SQL Server

Mark Simms marksimms at verizon.net
Tue May 25 13:57:33 CDT 2010


Const strConn = "ODBC;DRIVER=SQL Server;SERVER=BP001;APP=Microsoft Office
2003;WSID=PHL0549;DATABASE=WFMREPORT;Trusted_Connection=Yes"

Something like the above ?

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Tuesday, May 25, 2010 2:34 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Get an updateable ADODB recordset form SQL Server
>
> I use a trusted connection (there is no username / password)
> for my sql server.  I need a connection string to do that
> from Access, and I am not finding that.
>
> Anybody?
>
> --
> John W. Colby
> www.ColbyConsulting.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>





More information about the AccessD mailing list