G
Guest
Hi, I have a MS Access (2002) adp project connecting to a sql 2005 database.
I'm investigating the possibilities of using Database Mirroring in
conjunction with this adp project. I tested the setup of the mirrored db srv
with a small Dot.Net test app and that worked fine, providing I added the 2nd
mirrored server to the sql connection string with "Data
source=sqlsrv1;Failover Partner=sqlsrv2;"
Is there any equivalence to this to use with the build in sql client of MS
Access?
Are there any know issues with MS Access 2002 that are solved in later
versions?
Thanks for any assistance, Bart
I'm investigating the possibilities of using Database Mirroring in
conjunction with this adp project. I tested the setup of the mirrored db srv
with a small Dot.Net test app and that worked fine, providing I added the 2nd
mirrored server to the sql connection string with "Data
source=sqlsrv1;Failover Partner=sqlsrv2;"
Is there any equivalence to this to use with the build in sql client of MS
Access?
Are there any know issues with MS Access 2002 that are solved in later
versions?
Thanks for any assistance, Bart