Talk to java program via ms access class module?
Posted on 2011-03-08
Hi to every one:
I am asking about the class module in ms access.
Can I make one usable to all programming languages?
For instance , I need to make class module , accept the empID, and return all employee data.
Like his name, hireDate, department, … etc.
My scenario is:
1- Press A button on a ms access form.
2- The button trigger the class module .
3- The class module send the empID to a java program (which is connect to oracle database), and receive the rest of employee data from oracle database via the java program.
4- The reason is they don’t want the ms access program to connect directly to the oracle databse.
Is it poseple? And is it good approach to do so?