I have an ODBC connection to (Sage 100 ERP) databases with Microsoft Access. We have three companies that each has their own separate database. I have to log in each time I access a different database.
Is there a way to log out of an ODBC connection? Currently, I exit MS Access to log out of the ODBC connection and then open MS Access again to log into another Sage database .
Thank you for your help,