Hi all, would like a better understanding of best practice in setting up an ODBC link for Sage 100 VI jobs. We are currently still on Sage 100C Advanced 2018, and I am working to beef up what began as a home-grown Access solution to meet a specific accounting need, that has now become a full program in its own right. It's to the point now that I need to split the Access database but am a little confused as to the proper settings.

Based on what I found in the forums I thought I could point my ODBC link direcly to the back end, but when I attempt to use that as the VI Data Source I get "Unable to open [wdx][ODB]databasename". If I point ODBC to the front end I do not get the error, but none of the tables I need to source are listed because they reside in the back end.

I suppose I could create queries in the front end to access the data in the back end, but I question whether that is the most efficient method. Any suggestions would be welcome.