Access to oracle syncronisation

[maxpirate]

I have an access application which is used in four diff geographical locations, I want the data from individual applications to be pushed into a oracle server once in a month(Manually by button click), so that reports can be taken from central location. How do i configure this.?

My concerns are in identifying the updates that are made only during the particular month. Can we put a timestamp on the respective tables to identify this

[TheSmileyCoder]

There may be smarter ways of doing it, but what I do is add 2 date fields to each table, and then have the following code in the beforeupdate.
One datefield will be called dt_Created, other will be dt_LastChanged.

The code is shown below. I also keep track of who made the edits, by a custom UserID() function.

Private Sub Form_BeforeUpdate(Cancel As Integer)
If Me.NewRecord Then
    'If new record set the metadata for who created it, and when
    Me.cmb_CreatedBy = UserID()
    Me.tb_CreatedOn = Now()
End If
 
    'Set data on when this item was last changed.
    Me.tb_LastChangedOn = Now()
    Me.cmb_LastChangedBy = UserID()
 
End Sub

The fields are locked so users can't manipulate them. Depending on the situation they might even be hidden sometimes.

[maxpirate]

What i did try is something like i made a linked table in acess through microsoft odbc but whenever i try to insert into that linked table the password prompt comes up. Is there any way i can suppress this prompt by persisting the password for the odbc.

I will update the latest data to oracle table by using something like this
Insert into Linkedtable Select * from LatestUpdatesQuery

where LatestUpdatesQuery is a access query is created to get the latest records from last updates

[maxpirate]

any ideas on this ???