MS Access ODBC or Other Connection to Remote SQL Server
Posted on 2011-09-12
I was used to working with access accross my old employers network which made odbc very easy. Now i need to provide an access mdb which connects (odbc or dsnless) to a table on a remote server in a different country.
I can access the server using MSTSC to login, and have created a view, and a user with select access to the view...
My access mdb is simple.. the front end needs to connect to a view..... i have written the rest of the code using a flat file imported in access, but now i need to replace it with a connection to the db server...
And i have realised i have no idea how to go about this.
What do i need to do to get this accdb to connect to the remote servers IP ( and log in using the windows username and password i have been given, and then conect and retrive the view in odbc using a different sql username and password.
I can re-write my code using ADO if necessary.
This is quite urgent.