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

Hi, Leif looks swedish, in that case please send a mail to me, (e-mail address removed)
--
Officebyggaren
Kent Älmegran


"Leif" skrev:
 
L

Leif

Danish.

KentAE said:
Hi, Leif looks swedish, in that case please send a mail to me, (e-mail address removed)
--
Officebyggaren
Kent Älmegran


"Leif" skrev:
Click to expand...
 
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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sybase 11 dirvers- alternatives? 0
Accessing External DBMS tables 0
ODBC Driver for Sybase Database 3
Error 3151 - Connection Failed 0
Repeated Requests for GSuite password when first Accessing Outlook 365 after system start 0
get data from Sybase database by code not pass-through query 0
Get ODBC Windows User Name/password 2
How to (in vba code) identify if a linked ODBC table has a primary 6

Top