I am looking for a short term solution to connect to an Access database that is inside our firewall which only accepts SQL type calls.

The Connection string has to be done programatically. Any ideas?