Doug Murphy
dw-murphy at cox.net
Tue Feb 28 11:05:46 CST 2012
< Anyway, AFAICT it is not safe to use native client in Access if you plan to distribute the FE to workstations (most cases?).> Is there a security issue with the Native Client? Do you have a reference? Doug -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Tuesday, February 28, 2012 5:45 AM To: Access Developers discussion and problem solving Subject: [AccessD] Access 2010 Native client mystery solved I just attempted to create a new DSN directly in Access 2010 on my new test VM and guess what? No "Native Client" driver selectable for Access 2010 on that machine. Yesterday I was reading that the native driver client is installed when you install SQL Server, thus it appears (if I am reading this right) that you can only use the native client driver if you have intentionally installed the driver on a given workstation. How silly would that be? One would think it would be part of the Access installation package. Anyway, AFAICT it is not safe to use native client in Access if you plan to distribute the FE to workstations (most cases?). I for one am defaulting to the "SQL Server" driver from here on out. -- John W. Colby Colby Consulting Reality is what refuses to go away when you do not believe in it -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com