Automatic update from Oracle db to access db

[girlkordic]

I have a linked table from an Oracle database (that contains HR
information for my company)in an Access database. The Oracle DB is
updated on a daily basis. I would like one of my tables in Access to
update automatically so when an employee is hired, my access table
reflects that new employee that was added to the Oracle DB.
I should say I have read-only access to the Oracle Db.

Would I have to run an update query or can this be automated? If it
needs to be automated, can someone give me a clue on the code I would
need??

Many thanks

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Do you mean new records are appended to the Oracle db, or do you mean
that current records are changed?

If new records - you'd have to run a timed job that gets the new records
and appends them to your table. You'd have to have some way of
identifying new records: add date, start date, flag indicating a new
record.

If changed records - again you'd have to run a timed job that gets the
changed records. You'd have to have a way to identify the changed
records: same as for new records.

If the Access table has the exact same structure and data as the Oracle
table you may just want to delete all the records in the Access table &
run an insert (append) query from the Oracle table to the Access table.
This also would have to be a timed job, or a job that runs when the
Access application is first opened (this, only if there is only one
person using the Access front-end), or you could set up a CommandButton
to run the append whenever you want.

Timed jobs are run from a form, usually a hidden form, using the form's
Timer event. Read the Access Help articles on TimerInterval and "Timer
Event" for more information. There are also threads on this newsgroup
that discuss using the Timer events. Search Google Groups for Timer and
TimerInterval.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQlxCYIechKqOuFEgEQLAWACgvWgsjhuMwt1ZzDQJjI39OR mwEBsAoLD9
Fs65W6UhJ4MPiV5Nb2b/Hy0x
=XtI1
-----END PGP SIGNATURE-----

gi********@yahoo.com wrote:

I have a linked table from an Oracle database (that contains HR
information for my company)in an Access database. The Oracle DB is
updated on a daily basis. I would like one of my tables in Access to
update automatically so when an employee is hired, my access table
reflects that new employee that was added to the Oracle DB.
I should say I have read-only access to the Oracle Db.

Would I have to run an update query or can this be automated? If it
needs to be automated, can someone give me a clue on the code I would
need??