By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,889 Members | 1,297 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,889 IT Pros & Developers. It's quick & easy.

Automatic update from Oracle db to access db

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
-----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??

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.