ODBC Connection Close

[Damiankk]

I have an Access table linked with MAS 90 through an ODBC connection. I need to pull in data for multiple companies but once I enter the login and password information for the first company it no longer prompts for a new log in. How can I set the connection up so that it pulls in the data for the AP_InvoiceHistoryHeader once I enter the username and password and then when refreshed it prompts for a new log in so I can switch companies. I know this is a simple problem for someone. Thanks

Here is my connection

ODBC;DSN=SOTAMAS90;Description=MAS 90 4.0 ODBC Driver;Directory=M:\mas90;Prefix=M:\mas90\SY\, M:\mas90\==\;ViewDLL=M:\mas90\Home\;CacheSize=4;DirtyReads=1;BurstMode=1;StripTrailingSpaces=1;SERVER=NotTheServer;TABLE=AP_InvoiceHistoryHeader


Windows XP
Mas 4.3
Access 2007

 

[Remou]

This

http://support.microsoft.com/kb/170536

or ADO may suit. This

http://www.tek-tips.com/viewthread.cfm?qid=1506800&page=1

seems to have a suitable connection string.

 

[Damiankk]

I believe I need something in VB. Any ideas?