| Author |
 Topic  |
|
|
tomasalsbro
Average Member
Sweden
818 Posts |
 Posted - 08 May 2001 : 12:16:06
|
Help!!!
I removed a topic by mistake! I have a copy of the databas file (not so fresh I'm afraid) and wonder how to copy the topic and answers from my copy to the original databas file.
Cheers / Tomas
!-Keep distance in traffic-!
www.whiplash.pp.se |
|
|
HuwR
Forum Admin
United Kingdom
20601 Posts |
Posted - 08 May 2001 : 12:19:34
|
you could do it using access and an update query, but you will need to download your db's.
if you are using sql, just use dts and then use a query to select the records to transfer
|
 |
|
|
tomasalsbro
Average Member
Sweden
818 Posts |
Posted - 08 May 2001 : 12:38:32
|
Hi Huw and thanks for your quick reply!
I have Access 2000. Huw can you help me to construct the query?
I have identyfied the cat_id (=3), forum_id (=3), topic_id (=11), and the several reply_id (=75,89,92,93,97,99,101,102,116,117,171)
Tomas
!-Keep distance in traffic-!
www.whiplash.pp.se |
|
|
|
HuwR
Forum Admin
United Kingdom
20601 Posts |
Posted - 08 May 2001 : 13:08:17
|
ok open up you current db in Access, and then create a link to the topic table and reply tables in the backup db.
You will need to temporarily turn off the autonumber fields to do the insert.
Now create a query using the wizard, select the topic table from the backup db as the table. Drag and drop each of the fields into the result window at the bottom, don't us the *
set the topic_id as the criteria for the query in the TOPIC_ID column, now execute the query to make sure it returns the correct record. Now go back into design view, and from the menu, select Query|Append query and select the TOPICS table for the current db.
repeat the process for the reply table.
reinstate the autonumber fields
delete the links to the external db
compact your dtatabase to remove the data strored by the links.
that should be it
|
|
|
|
tomasalsbro
Average Member
Sweden
818 Posts |
Posted - 08 May 2001 : 14:46:29
|
OK, I will have a try - but how do I create a link from one db to diffferent tables in a nother db? I have never done that!
Tomas
!-Keep distance in traffic-!
www.whiplash.pp.se |
|
|
|
HuwR
Forum Admin
United Kingdom
20601 Posts |
Posted - 08 May 2001 : 15:42:21
|
choose Get external Data from the file menu, then choose Link tables.
|
|
|
|
tomasalsbro
Average Member
Sweden
818 Posts |
Posted - 09 May 2001 : 03:05:23
|
quote:
choose Get external Data from the file menu, then choose Link tables.
Huw,
I can't clear this out! I tryed but I can't manage it out. Can you help me if I send you my db files?
Tomas
!-Keep distance in traffic-!
www.whiplash.pp.se
Edited by - tomasalsbro on 09 May 2001 03:06:18 |
|
|
|
HuwR
Forum Admin
United Kingdom
20601 Posts |
Posted - 09 May 2001 : 05:56:46
|
yeah no prob, just mail them me, or mail me the ftp details.
|
|
|
| |
Topic |
|
Topic Locked
