I need to be able to create a connection through coding VBA. I will be putting the code in a module, but I do not know how to do this ( how to make the connection)
The ODBC32 has been setup with the AS400 source, that is there is an AS400 provider there.
I can import the table I need through the insert and then import table command from the menu, but I would like to do this coded.
Now how do I make a connection to this machine source ? I want to be able to update an imported table every time my access application opens, I cannot have it linked.
Please help me, if you need further details let me know.