[AccessD] Quick Update Solution

Terri Jarus jarus at amerinet-gpo.com
Tue May 13 16:00:41 CDT 2003


I could be wrong, but I would create an append query and if you have
your table set up correctly, it will not accept any duplicate records. 
There still may be a time issue dependent on the amount of data being
appended.

That's one suggestion.

>>> pblack at hotmail.com 05/12/03 02:38PM >>>
Is there a quicker/better way to append data than the method I
currently 
use:

select all records from table 1

move to first record in table 1

loop through every record in table 2 to see if a match occurs on
LINK_PT 
field

If there is a match it is skipped.

If there is no match then table 1 record is appended to table 2

Move to next record in table 1 and continue loop until .eof

I can do it this way but is there another quicker solution. As the
tables 
grow the speed slows. I am using A97 for the app.

Thanks

Paul

_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE*  
http://join.msn.com/?page=features/junkmail 

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com


More information about the AccessD mailing list