I have Oracle 8i tables linked into an Access database. I have a VB frontend that uses the data from Access. I am trying to read the linked Oracle tables from my VB code, but it keeps prompting me for the Oracle user name and password. How to I connect to these linked tables in Oracle using ADO recordsets without getting a login prompt? I have heard that I can create a DSN file with the login information in it, but I have a large number of users and don't want to install a DSN file on their computers. Is there another way?

Meg.

Import the data into Access rather than liknking to it.
You also could just read the information from Access regarding what the resource is that is being linked to, and build a connection to those same data into your VB.

I can not import the data because it is being updated on the Oracle side as well. I need to see current changes. I could connect directly to Oracle, which I do in other places, but there are limitation to what you can do with a recordset. Plus I have written all the code to write to Access tables and want to save time by not having to rewrite all the code with the ODBC connection limitations. That is why I am hoping to find away to make these linked tables work. Thank you though for time and the response!!

What if you connected to Oracle, created a temp table from the recordset, made your changes, then used a recordset to read the temp table back into Oracle?

It wouldn’t exactly be “live” data, but in some cases this is actually good enough.