Re: Linking to Oracle
- From: lcox400w <lcox400w@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 6 Jan 2010 08:14:01 -0800
Thanks for the info. The oracle client is on each machine already, I will
look into automating the ODBC installation and create the link on the front
Do you have a sample code of how to create the odbc connection and
incorporate the password so the users dont have to do that?
"Clifford Bass via AccessMonster.com" wrote:
Since the Oracle client installation is complicated, it is probably best
to do that manually on each machine. Or provide the Oracle installation
program(s) and explicit instructions for your situation. You could create a .
REG file with the Oracle ODBC registry settings to simplify things somewhat.
The user would simply double-click it and the Oracle ODBC settings would be
imported into the registry. Installation program wizards may simplify things
Once you create the linked table manually in the front end, whenever
someone attempts to use it for the first time after opening the Access FE
database, it will automatically prompt for the Oracle logon credentials. So,
no need to do the connection in code. Or, if it is using generic creditials
set up for just this purpose, you could tell Access to save the password when
creating the linked table.
Hope that helps,
I have a split database we have been using for about a year. I want to add a
new feature to the application that will query a table in our oracle DB to
retreive some information to reduce duplicate data entry. I know how to link
to the oracle database manually but I'm not sure how to proceed with doing
this in VBA.
None of my client machines have the ODBC Connection on them. So my first
questions are, do I create the link manually on the front end of the app and
then install the ODBC on each client machine? Or is there a better/easier
method of doing this?
My second question is, I'm not sure how to use VBA to open the database
table I want so I can then run the query. Since the database is not part of
my tables, I have never opened a second database through VBA before if
someone can help point me in the right direction with a sample?
thanks in advance.
Message posted via http://www.accessmonster.com
- Re: Linking to Oracle
- From: Clifford Bass via AccessMonster.com
- Re: Linking to Oracle
- Prev by Date: Re: Upgrading from Access 2000 template to Access 2007 template
- Next by Date: Re: Linking to Oracle
- Previous by thread: Re: Linking to Oracle
- Next by thread: Re: Linking to Oracle