By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,550 Members | 2,757 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,550 IT Pros & Developers. It's quick & easy.

Aonnect Access as a Front ENd with ORACLE Back End

P: 9
Hi All

I want to connect Access as a FRONT END and ORACLE as a BACK END…
I want to connect both of them to pull data from ORACLE into ACCESS interface.

Thanks,
Bhavin
Sep 11 '07 #1
Share this Question
Share on Google+
1 Reply


Jim Doherty
Expert 100+
P: 897
Hi All

I want to connect Access as a FRONT END and ORACLE as a BACK END…
I want to connect both of them to pull data from ORACLE into ACCESS interface.

Thanks,
Bhavin
The easy way LINK the tables via ODBC

File....Get External Data...Link Tables....Files Of Type...ODBC Databases...Create your DSN on the client machine and follow the prompts. The tables will then appear in the database window.

Other than that you are into DSNless connections in code using unbound forms and communicating using recordset collections

Regards

Jim
Sep 12 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.