Hi,I am trying to connect to Salesforce via MS Access. When I try to login, I get an error message 'ODBC--connection to '{{Salesforce}}' failed'. When I look at my login history in Salesforce, it says 'Partner Product, Invalid Password, SimbaTechnologies/ODBCDriver/'. However, I can login from another application with exactly the same credentials and I get connected.It is not the ODBC driver, as other people can connect from MS Access to Salesforce on my laptop.What am I missing?Thanks!Kris
If you are connecting to a Sandbox, you need to include the test url in the additional parameters.Additional Connection String Parameters:URL=https://test.salesforce.com