Re: SQL*Net 1 ==> SQL*Net 2

Hi Dan,

when linking new tables into you Access-DB you can specify that Access store user and password. The disadvantage is that it's stored in plain text in the tabkle description.

Dan Hopkins wrote:
>
> Kevin P. Fleming wrote in message
> <34C91445.ED14DDB3_at_access-laserpress.com>...
> >No, you can't do that, but you can certainly update the table attachments
 in
> >Access to use the new connect string format. This can be using either
> >Access' Linked Table Manager or from Access Basic code, your choice.
> >
>
> Got it. Thanks (and to everyone else that replied).
>
> The linked table manager seems to do the job ...... although selecting the
> datasource, and
> typing the associated password MANY times is a killer ;o) (although not
> enough to warrant
> playing around with VB/Access for now)
>
> Cheers.
>
> -------------------------------------------------
> Dan Hopkins
> Systems Admin & Development
> UK Online Ltd.
> email: dan_at_ukonline.co.uk
> -------------------------------------------------
 

-- 
Regards

Matthias Gresz    :-)