MAS 200 ODBC Auto-login in MS Access 2000

[valkyry]

I'm looking for a function??? to put in a module that'll get called out in any query to auto-login into MAS 200 from MS Access 2000.

I'm not a programmer, so all the help to the specifics would be wonderful!

Here's the deal, I have a macro that'll download and process MAS 200 data in MS Access and it's done nightly. The macro contains many queries (from make-tables to appends to updates). I want to automate this.


I have an automating program called AutoMate that'll run the macro at a given date and time . . .


The only problem is you have to log into MAS 200 each time the db is opened . . .


HELP!?

 

[Guest_imported]

You can use the following connection string when you link in your tables.

"ODBC;DSN=SOTAMAS90;UID=" & UserID & "|" & Company & ";PWD=" & Pword & ";COMPANY=" & Company

Slade Hornick

http://www.hornickconsulting.com