Since my forum has be hacked and 15 000 + messages have been deleted by a f... 10 years old boy, I am using an older version of the forum.mdb file. But there are a lot of new topics and replies remaining on the hacked dabatase that I would like to transfer to the one I am now using.
However this seems to be impossible mission:
First there is the "relationship" issue Then there is the "index number" issue that prevents me from importing content and keep the exact same index numbers for my topics and replies. Consequence is that many replies have a "topic ID" field that does not correspond to the correct Topic and this is a pure mess. What I tried was to change the index fields from "autonumber" to "integer". That way, I was able to transfert the missing content. But when I tried to switch back the "index" fields to "autonumber", access 2000 says this is not possible.
I am really confused and I would appreciate if someone could provide me with a solution...
The only way I know is to write a special script with two connections and do the copy-insert repeatedly. Needs a lot of work thou. Perhaps there is someone who did this before... Will be a very nice MOD.
Posted - 09 May 2002 : 12:18:01
