Accessing Acess/Oracle Database W/Password
Try this
If db is the handle to the Access database with the Attached table
before doing any action on the table i.e creating record or executing SQL
you should
db.TableDefs("OracleTableName").RefreshLink
Quote:
> Hello.,
> I have a little problem, I have a MS Access database that is Linked to a
> Oracle Server database. When I try to access this from within VB5 I get
> prompted with the "Login to Oracle" box. That would be fine but I am
> porting the program to be a Internet (WWW) application. I have to somehow
> incorporate the Login within the program. I would really like to find out
> how. If anyone has a clue please send me an e-mail. Thanks.
> Mike Meklenschek
> WEB Administrator
> Bombardier Inc. Defense Systems Division.
