Access Synchronization with oracle and power point reporting

[maxpirate]

application is built on an MS Access database utilizing the GUI facilities of MS Access. Copies of this application are used stand alone in 4 different geographical locations.The users in these locations send the respective mdb files to a seperate team for consolidation. The reports from each mdb file is generated separately and consolidated into one single report. We wish to consolidate all the stand alone mdb copies into a single centralized database(Oracle ) and generate consolidated reports from the central DB.

Can someone give me heads up on the synchronization of data between the oracle server and the different mdb files. The users may wish to work offline but when they wish to send/get updated information to oracle, they should be able to do it.
Second, how to prepare charts in powerpoint based on data present in oracle through MS Access VBA.

Any help is greatly appreciated.

[MMcCarthy]

There are two ways you can do this.

Either link the oracle tables to the mdb database(s) using odbc and use queries to update or append data.

The other way is to do this using vba coding. You would have to create a connection to the oracle database and then use recordsets to connect to the oracle tables.

You can then either use a different connection for each of the mdb databases and recordsets to open the tables. Then use code to synchronise the data. Or you can consolidate the mdb databases into one and use that as the core database into which this code is added.

[maxpirate]

But the client does not want to link the tables directly to oracle. Is their any code samples for generating a graph based on data in access tables and paste the same in powerpoint.?

[MMcCarthy]

My advice is to output the data to excel and do any chart creation there. Then you can link it ot powerpoint.

[maxpirate]

how do we push data into oracle using a connection ? what would be the insert statement?