Hey bigandfat,
Not sure if your ODBC Connection problem is still current, looking at the dates, but I recently had the same one.
I am connecting to a OpenLink Generic 32 Bit Driver server instead of ACCESS but the principles should be the same.
Solution below.
var
AliasInfo DynArray[] String
endVar
removeAlias("SERVER_CONNECT"
AliasInfo["SERVER NAME"] = ""
AliasInfo["USER NAME"] = ""
AliasInfo["OPEN MODE"] = "READ ONLY"
AliasInfo["PASSWORD"] = ""
addAlias("SERVER_CONNECT", "OpenLink Generic 32 Bit Driver", AliasInfo)
setAliasPassword ("SERVER_CONNECT", " "
I used a space for the Alias password, as shown on the last line. I don't remember why but if you put a blank string (""

the login information popup dialog comes up.
The code shown is very raw and could most likely be tidied up a bit, i.e. the 'AliasInfo["PASSWORD"] = ""' line is probably not needed.
Regards
Steve