http://www.sqlservercentral.com/blogs/robert_davis/2010/05/07/Database-Mirroring-FAQ-_2D00_-Is-Mirroring-Supported-by-MS-Access-front_2D00_end/

Printed 2014/10/24 12:06PM

Database Mirroring FAQ: Is Mirroring Supported by MS Access front-end?

By Robert Davis, 2010/05/07

Question: Is Mirroring Supported by MS Access front-end?

The following question was posted on a SQL Server discussion group. My reply follows.

 

Is the MS SQL Mirroring supported by MS Access Frontend (.adp) ?

 

We have MS SQL Server 2008 Developer Edition.
The Mirroring is configured and works fine for .Net Applications.
See for example http://msdn.microsoft.com/en-us/library/5h52hef8.aspx for using Mirroring in ADO.NET

But we have also MS Access Frontend Applications. How to use the mirroring in this case?

Where the second copy of the database must be configured?

 

My answer:

 

In order to specify the mirroring partner, you have to use the SQL Server Native Client 10.0 client for the DSN and specify the database name for the connection. The generic SQL Server DSN interface doesn’t support it.

New Data Source

Specify Failover Partner


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.