I have a backup of the forum from a couple of days ago. Is it easy to go and pick the topic out of the back up, and add it into the newer version? Anyone tried this?
I can extract the topic and replies using a query quite easily, but unsure if I could then go and paste records into newer database without messing things up. Things like Forum_Reply.Reply_Id etc etc
if you use SQL it can be done, but not in Access because of the ID field, in SQL you can turn it off and back on again. To do it in access you will need to reinsert the topic at the end of the topic table so it gets a new topic_id, then if it had any replies you will need to insert them into the reply table and change the topic_id to point at the updated topic_id
Topic Locked
Posted - 15 May 2006 : 08:57:56
, but not that easy to explain to someone who doesn't