I am using a tool called PSEnlist to drag a table from LDAP via ODBC into
Microsoft Access 2000 and am trying to automate this task (to run
overnight). The problem is when I run the module, I get a dialog box
prompting for my LDAP login and password (I am anonymously logging in
anyway). How can I send the keystrokes for this? Or do I put the details in
the ODBC connection string. Here is my code:

call TransferDatabase(acImport, "ODBC Database",
"ODBC;DSN=LDAPUser;DATABASE=","employees","Employees",,True)

Any ideas?
I can't put the Sendkeys method after this line as the dialog box suspends
it.
I tried putting UID="";PWD="" in the connection string, but then the
connection failed.
TIA,
Joe