Hi everybody, my first post here.
I was a VBA programmer in Access long time ago and now I want try to program again to create a new procedure for a data entry that use Oracle tables connected.
I have created the link to the Oracle database and selected the tables that I need, everything is fine.
The problem start when I create the form where I use combo box to select the data to insert reading the Oracle tables.
Everytime the system show me a windows where I have to enter the credentials to connect to the Oracle database.
What I need is to create the connection only once and then work on my entry form to select the data to insert on my combo boxes without to enter everytime the conncetion credentials.
Can somebody explain me how to do it?
Many thanks