D
David
Hello,
I am trying to prevent bloat on DB1. Currently I have an ODBC Connection to
an oracle database. My code goes out and copies down thousands of records to
DB1, then updates the user's backend database then deletes the records from
DB1. I have the routine on a timer to execute several times a day.
This process does not follow good practice, but I am unable to update the
user's tnsnames.ora file to allow them to connect to the Oracle database.
I will create a DB2, on the startup form (on open event, have code that
copies down these thousands of records, runs the updates, deletes the records
and quits/closes db2, and set to compact on close.
Goal: I would like to have DB1 open DB2 on a timer event. Prefer to have
this occur in the background and not visable. This would allow DB2 to
complete the updates to the user's backend database. This will prevent bloat
of DB1. Since DB2 will compact on close, it will prevent bloat of DB2.
Any sights you can direct me to or code snipits would be very helpful.
Thank you,
I am trying to prevent bloat on DB1. Currently I have an ODBC Connection to
an oracle database. My code goes out and copies down thousands of records to
DB1, then updates the user's backend database then deletes the records from
DB1. I have the routine on a timer to execute several times a day.
This process does not follow good practice, but I am unable to update the
user's tnsnames.ora file to allow them to connect to the Oracle database.
I will create a DB2, on the startup form (on open event, have code that
copies down these thousands of records, runs the updates, deletes the records
and quits/closes db2, and set to compact on close.
Goal: I would like to have DB1 open DB2 on a timer event. Prefer to have
this occur in the background and not visable. This would allow DB2 to
complete the updates to the user's backend database. This will prevent bloat
of DB1. Since DB2 will compact on close, it will prevent bloat of DB2.
Any sights you can direct me to or code snipits would be very helpful.
Thank you,