var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Access Data Project (ADP) to an Oracle database
Using Access Data Project to Oracle
I have an ADP project attached to a SQL database, for producing reports (works fine over remote connections), but I now need it to work on Oracle
How do I run reports from an ADP front end using an Oracle database?
I can access data in the Oracle tables with ADO recordsets, but how would I run reports, as Access reports require an attached table/view?
Is their an OLE DB Provider for Oracle that will work with ADP's?
I'm using Access 2000, connecting to Oracle 8
Last edited by Steve_T; 12-17-03 at 06:25.
You can use the Oracle OLE DB driver supplied on the Oracle 8i/9i client. You can then create linked tables against which your reports should be able to run.
I have Oracle OLE driver 8i, but I am still unable to get the Oracle tables to connect, Works fine in an Access.MDB but not in an Access ADP project
I'm trying to connect Dynamically in code
Last edited by Steve_T; 12-22-03 at 11:54.