Making an SQl query and printing the value in a text box

[shandoo27]

My requirement:

I want to extract a particular value from the link table ( given between Oracle and MS access 2007) and print it onto a text box.

For example , suppose the user gives the company name and employee id i have to look up the table and print the employee name. this employee name has to be printed onto a text box in the access form .

Could anyone give me a sample code for the above requirement :

I would also be thankful if you could also mention the reqd VBA code used in connection to oracle database via the link table while making a SQL query.

Thanks in advance for the help .

 

[ColinD]

Why not just use ODBC to link Access to Oracle? Then you can just create Access queries and update forms in the usual way. That's what we do with SQL server and Access 2007, and it works pretty well.

Colin

 

[shandoo27]

Are you sure that a normal sql query will be enough to update a table in Oracle ? Because some people say that modifying link tables don't modify the database in oracle, but then they say we need to set up some server or something ?