access oracle database from MS access

[shandoo27]

Hi,
I have a set of forms in my MS access database and have linked it to oracle database with ODBC. With the link tables now available , could someone help me out as to how to write VBA code for the buttons so as to retrieve info from the oracle database ?

I would be happy if you could provide a sample VBA code for this querry i.e. when the student id is selected through drop down list and Search button is clicked it must go and look up in the table in oracle and must give all the students details .

Thanks in advance for the help

 

[gemma-the-husky]

once tables are linked, they should work as any other acccess table

yopu may want to be careful about updating the oracle database though. i suspect it would be easy to damage the data, if you are not careful.