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

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?
 
G

Guest

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
 
N

Norman Yuan

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top