I am having a similar problem linking tables from Oracle 8i. I have a VB front end with data kept in Oracle & Access. I want to link the tables in Access from Oracle and access the tables from the VB code like they were Access tables. I have linked the tables and tried to run the code and as you might expect it prompts me for the Oracle password. I am trying to get rid of this prompt, but I don't want to create a new DSN that then needs to get loaded on everyone's computer. I saw the code in this chain, and I am going to try that (with the Oracle connection string), but is there some way in VB code (not Access VB) to access the linked tables with a user name and password using the same connection used to access the Access tables? Here is my Access connection string:
gcnnString = "Provider = MSDataShape; " & _
             "Data Provider = Microsoft.Jet.OLEDB.4.0; " & _
             "Data Source=" & db_path & "; " & _
             "Jet OLEDB:Database Password=" & pwd

Oh and I am using ADODB recordsets.

Thank you for your help!
Meg.

I tried using the code provided in my VB frontend to Access and it doesn't error, but it doesn't work either. The table does not get linked. Any idea why this would happen. Note that I hardcoded the code to link 1 specific table just to see it work first.

I also tried created a macro in VB that uses the transferdatabase action to link tables. This does work, and I can rename the macro to AutoExec, but if the table exist, it does not delete it first. Is there a macro (name) that automatically runs at exit like the AutoExec runs at startup? Not that that will really work in a multi-user environment, but it would be nice to know. I think I can play with the RunCode code to just delete a table then do the transfer database.

Meg.

Okay I got the Macro to work and it refreshes the link at startup with the username and password. However, when I try to access it from the VB code, it still prompts for a password with the wrong user name. So, I am at square one.

Any help would be most appriciated!
Meg.

hi friends,

can anyone help me to find username and password to connect odbc to asp.net. And if anyone know default username and password for connecting asp.net to odbc