Thanks for that.

However, users cannot connect via the VB app unless they have the relevant
driver installed. In this case they need the Oracle driver/client
components. Its not feasable to get everyone to install the Oracle Client
software.

Is there a way to automatically update an Access Table with data from an
Oracle table (eg. as with DTS in SQL Server?) This way then users wont need
drivers.

Thanks
Niall

-----Original Message-----
From: John Pace [mailto:jpace@h...]
Sent: 14 August 2002 15:23
To: professional vb
Subject: [pro_vb] RE: Linked Tables


In Access 2000, when you are linking the table, it has a check box that
reads "Save Password."  Check that and it won't ask again.

John

-----Original Message-----
From: Niall Hannon (ext. 772) [mailto:Niall.Hannon@f...] 
Sent: Wednesday, August 14, 2002 8:15 AM
To: professional vb
Subject: [pro_vb] Linked Tables

Hi

Is there a way of preventing my VB app from asking for a password when
it
tries to access records from an ODBC linked table in Access. The linked
tabel in Access links to an Oracle database. This works fine but when I
want
the VB app to read from the Oracle linked table then it asks for a
password.
Obviously the user doesnt like this.

Maybe I should import the table into Access and try a way to keep it
uptodate using DTS or something?

Anyone got any ideas?

Thanks
Niall


************************************************************************
**
The information contained in this e-mail is confidential,
may be privileged and is intended only for the use of the
recipient named above. If you are not the intended
recipient or a representative of the intended recipient,
you have received this e-mail in error and must not copy,
use or disclose the contents of this email to anybody
else. If you have received this e-mail in error, please
notify the sender immediately by return e-mail and
permanently delete the copy you received. This email has
been swept for computer viruses. However, you should
carry out your own virus checks.


Registered in Ireland, No. 205721. http://www.FINEOS.com
************************************************************************
**



---
Visual C# - A Guide for VB6 Developers
This book will make it easy to transfer your skills 
from Visual Basic 6 to C#, the language of choice 
of the .NET Framework.
http://www.wrox.com/ACON11.asp?ISBN=1861007175&p2p0059




---
Visual C# - A Guide for VB6 Developers
This book will make it easy to transfer your skills 
from Visual Basic 6 to C#, the language of choice 
of the .NET Framework.
http://www.wrox.com/ACON11.asp?ISBN=1861007175&p2p0059