Accessing External DBMS tables

[Leif]

I have tables in Access linked to Sybase (same as MS SQL Server) 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