Pass through query in Access 2000 to MVSDB2 mainframe prompts for ODBC.
I am trying to find out why when doing a pass through query to an MVSDB2 mainframe table from access 2000, the odbc prompt pops up? How do you invoke a specific odbc within the query? TIA
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I would add that you have to open the query in design mode and right click on the title bar to get the correct properties to open. Took me a few minutes to find.
Glad you found it. Getting the property sheet differs between versions so I was waiting to see if you'd ask how and indicate which version. In 2007 and later there's an option on the ribbon to show property sheet.
OM Gang
OM Gang
ASKER
example.bmp