<?xml version="1.0" encoding="utf-8" ?>
<?xml-stylesheet type="text/xsl" href="RSS_xslt_style.asp" version="1.0" ?>
<rss version="2.0" xmlns:WebWizForums="https://syndication.webwiz.net/rss_namespace/">
 <channel>
  <title>Web Wiz Support and Community Forums : Merging two databases</title>
  <link>https://forums.webwiz.net/</link>
  <description><![CDATA[This is an XML content feed of; Web Wiz Support and Community Forums : Web Wiz Forums : Merging two databases]]></description>
  <copyright>Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved.</copyright>
  <pubDate>Mon, 13 Apr 2026 15:20:08 +0000</pubDate>
  <lastBuildDate>Mon, 25 Jul 2005 22:58:47 +0000</lastBuildDate>
  <docs>http://blogs.law.harvard.edu/tech/rss</docs>
  <generator>Web Wiz Forums 12.08</generator>
  <ttl>360</ttl>
  <WebWizForums:feedURL>https://forums.webwiz.net/RSS_post_feed.asp?TID=15977</WebWizForums:feedURL>
  <image>
   <title><![CDATA[Web Wiz Support and Community Forums]]></title>
   <url>https://forums.webwiz.net/forum_images/web_wiz_forums.png</url>
   <link>https://forums.webwiz.net/</link>
  </image>
  <item>
   <title><![CDATA[Merging two databases : I think you&amp;#039;ve created a...]]></title>
   <link>https://forums.webwiz.net/merging-two-databases_topic15977_post87702.html#87702</link>
   <description>
    <![CDATA[<strong>Author:</strong> <a href="https://forums.webwiz.net/member_profile.asp?PF=19649">JJLatWebWiz</a><br /><strong>Subject:</strong> 15977<br /><strong>Posted:</strong> 25&nbsp;July&nbsp;2005 at 10:58pm<br /><br /><P>I think you've created a pretty serious problem for yourself.&nbsp; In my opinion, in a situation like that, you should have shut down the forum until repairs were made.</P><P>I haven't used the Access version in several years, but I assume the ID field is auto numbering, so you <EM>can</EM> just copy and paste from the backup MDB into the production MDB.&nbsp; The auto-numbered Thread_ID will set new ID numbers for the records being pasted in.&nbsp; You should keep a record of the ID's that are created&nbsp;during the&nbsp;combining of the data.&nbsp; If only the tblThreads was emptied, then the links to at least Topic, Forum, and Author should be intact.&nbsp; However, since you said the users and polls are having the same problem, are we to assume that every last table was blanked out?&nbsp; If all the tables have been rebuilt from ID zero then there is no way you can do a simple import.&nbsp; It's not impossible, though it will require a lot of manual adjustments.&nbsp; Someone with an in-depth understanding of how WWF works and Access expertise will have to do the work.</P><DIV>I think even if someone deleted all the records, the auto ID fields would continue from where they left off, so it seems that something else might have happened like someone completely replaced the MDB file.&nbsp; But that would have required you to set up the forum configurations again.&nbsp; Did you have to do that?</DIV><P>In any case, if you suspect that someone acquired your Admin password, you need to figure out how to prevent that.&nbsp; Using the web interface to perform a brute force attack against a 160-bit encrypted password would be highly impractical.&nbsp; Such an attack would be far more plausable (though still not a trivial task) if the attacker was in possession of the hash and salt, but even then a hacker would be wasting his time to try break the password since there are easier ways to acquire admin rights in WWF once in control of the raw data.&nbsp; You have to take every precaution and use every "best practice" to guard the MDB.&nbsp;&nbsp;Make sure&nbsp;your host (FastHosts?)&nbsp;has configured the location of the MDB file so it is outside&nbsp;and inaccessible from the wwwroot.&nbsp; It should not be in a virtual folder.&nbsp; Make sure you don't have any domain user accounts with access to the folder wherein the MDB is stored.</P>]]>
   </description>
   <pubDate>Mon, 25 Jul 2005 22:58:47 +0000</pubDate>
   <guid isPermaLink="true">https://forums.webwiz.net/merging-two-databases_topic15977_post87702.html#87702</guid>
  </item> 
  <item>
   <title><![CDATA[Merging two databases : im sure you are able to import...]]></title>
   <link>https://forums.webwiz.net/merging-two-databases_topic15977_post87689.html#87689</link>
   <description>
    <![CDATA[<strong>Author:</strong> <a href="https://forums.webwiz.net/member_profile.asp?PF=2216">dj air</a><br /><strong>Subject:</strong> 15977<br /><strong>Posted:</strong> 25&nbsp;July&nbsp;2005 at 5:01pm<br /><br />im sure you are able to import into a table without creating new one<br>]]>
   </description>
   <pubDate>Mon, 25 Jul 2005 17:01:49 +0000</pubDate>
   <guid isPermaLink="true">https://forums.webwiz.net/merging-two-databases_topic15977_post87689.html#87689</guid>
  </item> 
  <item>
   <title><![CDATA[Merging two databases : The Import tool isn&amp;#039;t working...]]></title>
   <link>https://forums.webwiz.net/merging-two-databases_topic15977_post87688.html#87688</link>
   <description>
    <![CDATA[<strong>Author:</strong> <a href="https://forums.webwiz.net/member_profile.asp?PF=17953">AlexDP</a><br /><strong>Subject:</strong> 15977<br /><strong>Posted:</strong> 25&nbsp;July&nbsp;2005 at 4:36pm<br /><br /><font face="Arial, Helvetica, sans-serif">The Import tool isn't working - it's just creating a new table with the data not adding it to the tables already there.<br>I can't just copy and paste because of the primary keys. Is there a wayI can turn them off, paste the data and then make them primary keysagain?</font>]]>
   </description>
   <pubDate>Mon, 25 Jul 2005 16:36:46 +0000</pubDate>
   <guid isPermaLink="true">https://forums.webwiz.net/merging-two-databases_topic15977_post87688.html#87688</guid>
  </item> 
  <item>
   <title><![CDATA[Merging two databases : try using the import tool  using...]]></title>
   <link>https://forums.webwiz.net/merging-two-databases_topic15977_post87686.html#87686</link>
   <description>
    <![CDATA[<strong>Author:</strong> <a href="https://forums.webwiz.net/member_profile.asp?PF=2216">dj air</a><br /><strong>Subject:</strong> 15977<br /><strong>Posted:</strong> 25&nbsp;July&nbsp;2005 at 4:18pm<br /><br />try using the import tool<br><br>using identity creation, im not to sure on this<br><br>i have done this with a SQL database but not access<br>]]>
   </description>
   <pubDate>Mon, 25 Jul 2005 16:18:06 +0000</pubDate>
   <guid isPermaLink="true">https://forums.webwiz.net/merging-two-databases_topic15977_post87686.html#87686</guid>
  </item> 
  <item>
   <title><![CDATA[Merging two databases : My forum was recently hacked  (brute...]]></title>
   <link>https://forums.webwiz.net/merging-two-databases_topic15977_post87685.html#87685</link>
   <description>
    <![CDATA[<strong>Author:</strong> <a href="https://forums.webwiz.net/member_profile.asp?PF=17953">AlexDP</a><br /><strong>Subject:</strong> 15977<br /><strong>Posted:</strong> 25&nbsp;July&nbsp;2005 at 4:08pm<br /><br /><font face="Arial, Helvetica, sans-serif" size="2">My forum was recently hacked (brute force password cracker on admin account I think) and all the posts were deleted.<br><br>Instead of closing the site I allowed members to continue posting in one new forum (all others were deleted too). As I have a backup (there is a gap between backup and hack time though) I want to restore the old posts and keep the new ones.<br><br>I assumed I could just add the new ones to the backup database but because of the primary key fields it is not working. The primary key is being changed, for example Post ID 9587 is being changed to 8541, therefore all replies will be jumbled up, etc.<br><br>The same is happening with members/users, polls etc.<br><br>How do I merge the two databases together? All help gratefully received.<br><br>I'm using WWF v.7.92 although this is really a databse probelm, using MS Access 2000.<br></font><font face="Arial, Helvetica, sans-serif" size="2"></font>]]>
   </description>
   <pubDate>Mon, 25 Jul 2005 16:08:45 +0000</pubDate>
   <guid isPermaLink="true">https://forums.webwiz.net/merging-two-databases_topic15977_post87685.html#87685</guid>
  </item> 
 </channel>
</rss>