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!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Best way to update multiple tables

Status
Not open for further replies.
slugo

slugo

Programmer
Dec 16, 2001
15
US
Hi.

I'm wondering what the best way is to update multiple tables. Right now I have 4 different Update queries to update 4 different tables. It is killing out my program with all the work it has to do. All the tables are 10,000+ records long so you can imagine the time it takes to do each query. Well thanks for your help.

TIA
-Mike
 
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
UPDATE DAO RECORDSET 1
Replies
11
Views
248
strongm
strongm
2009luca
  • Locked
difficult to crteate a query very complicated 1
Replies
9
Views
876
Andrzejek
Andrzejek
2009luca
  • Locked
  • Question
USE find instead to loop
Replies
2
Views
205
Andrzejek
Andrzejek
marty1944
  • Locked
  • Question
error code 380 when trying to run the visual basic v6 deployment wizard
Replies
1
Views
357
marty1944
marty1944
sal21
  • Locked
  • Question
how to read the coordinates in from this file
Replies
3
Views
213
Ken01
Ken01

Part and Inventory Search

Sponsor

Back
Top