Hi,
Does anyone know if you can setup a failover server when creating an Access ADP, the connection string you would use would be something like
"Data Source=A;Failover Partner=B;Initial Catalog=AdventureWorks;Integrated Security=True;"
but when you use the connections properties in Access I cant see anywhere to set the failover server.
Thanks,
Gavin,
Update: Looks like this isn't possible with Access ADP's unless anyone else know differently as I have just tried updating the connection string in VBA with the following and access strips out the Failover Provider and updates the rest:
Does anyone know if you can setup a failover server when creating an Access ADP, the connection string you would use would be something like
"Data Source=A;Failover Partner=B;Initial Catalog=AdventureWorks;Integrated Security=True;"
but when you use the connections properties in Access I cant see anywhere to set the failover server.
Thanks,
Gavin,
Update: Looks like this isn't possible with Access ADP's unless anyone else know differently as I have just tried updating the connection string in VBA with the following and access strips out the Failover Provider and updates the rest:
Code:
Application.CurrentProject.OpenConnection "Provider=SQLOLEDB.1;Data Source=MIS-Test;Failover Partner=B-Test;User ID=myuser;Password=mypassword;Initial Catalog=MISHdesk"
Last edited:
