Providing Login ID & Password to Sybase

L

Leif

I have tables in Access linked to Sybase through an ODBC connection. When I
run a query that accesses those Sybase tables I'm prompted for a Sybase login
information (server name, login id, password, and database). I can enter
that once, and then Access remembers the information for that session.

I want to be able to code that information into VBA so that the user is not
prompted to provide that information. Could someone tell me how this is
done? Thanks.

Regards,
Leif
 
K

KentAE

Hej Leif

I have the same problem, did you get some help or did you find out a
solution by your self? It should be nice if you can provide me your solution.
Thank´s

--
Officebyggaren
Kent Älmegran


"Leif" skrev:
 
Top