Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Updating a database
- Thread starter Bertramp
- Start date
Truncate = no records exist. That's a definite performance-killer.
Instead of truncating, you should do a CRUD routine that inspects the table for records that need to be deleted, added, and updated, and makes the necessary updates. If you have a file-based data system like Access, put a secondary MDB out there with the new data, and run the CRUD routine on the production MDB.
Phil Hegedusich
Senior Programmer/Analyst
IIMAK
-----------
I'll have the roast duck with the mango salsa.
Instead of truncating, you should do a CRUD routine that inspects the table for records that need to be deleted, added, and updated, and makes the necessary updates. If you have a file-based data system like Access, put a secondary MDB out there with the new data, and run the CRUD routine on the production MDB.
Phil Hegedusich
Senior Programmer/Analyst
IIMAK
-----------
I'll have the roast duck with the mango salsa.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question