Hi there, I can construct a pass-through query to access my accounting software's database using odbc, but I have to type in the connection string parameters such as username, password, DSN name etc to the ODBC Connect Str of the Query Properties - for each query. What I would like to do is have the connection string parameters (username, password...) for the pass-through query pulled from a Table in the same mdb. In other words, have a table with the connection string parameters then use VBA to build the pass-through query with the connection string based on the table supplied parameters. I've struggled with the VBA to do this and cannot get it right. I don't have a lot of experience with VBA. Can anyone provide me with some VBA that will create a pass-through query pulling the ODBC connection string parameters from a Table? Thanks in advance.