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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Copying History Files?
- Thread starter ClikChik
- Start date
get the account number of the one you want to copy, and the one that you want to replace this with. Find the entries within the conthist table, and then copy these,highlight the AccountID of the ones you have just copied and overwrite this with the new accountid number.
I would use access to do this, do not use excel, due to the notes column would not show.
Hope this helps...
I would use access to do this, do not use excel, due to the notes column would not show.
Hope this helps...
- Thread starter
- #3
It quite easy, but do not forget to make a backup up before you do this.
Do not worry about the RECID, keep it the same as the records you are taking the notes from.
Then rebuild the db after you have done just to make sure there are no errors.
Glad to be of some help
Do not worry about the RECID, keep it the same as the records you are taking the notes from.
Then rebuild the db after you have done just to make sure there are no errors.
Glad to be of some help
- Status
Similar threads
- Locked
- Question