How do I connect an Access 2003 project to oracle 9i database?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to use an Access 2003 project to connect to an Oracle 9i database to
take advantage of Access 2003 project graphic interface. Is this possible,
and if so how do I make this happen?
 
Arvin Meyer said:
The easiest way is to set up a DSN (date source name) using the Oracle ODBC
driver.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access




Thank you for the reply; however, I'm using an Acess PROJECT and not a regular .mdb file. I'm familiar with ODBC connections using .mdb, but can't figure out how to get and Access PROJECT to connect. Any additional help is very much appreciated. TAB
Click to expand...
 
Access Project (*.adp) is spesically designed for SQL Server/MSDE. To use
Access as FE with other database server, you cannot use *.ADP. Do as Arvin
suggested with *.mdb.

regular .mdb file. I'm familiar with ODBC connections using .mdb, but can't
figure out how to get and Access PROJECT to connect. Any additional help is
very much appreciated. TAB
 
Back
Top