We help IT Professionals succeed at work.

'Unreplicating' an Access 2002 database

sprosser
sprosser asked
on
Medium Priority
347 Views
Last Modified: 2008-02-01
Does anyone know of a way to 'unreplicate' an Access 2002 database?
Comment
Watch Question

CERTIFIED EXPERT
Commented:
Hi sprosser,
Very messy business.
See item 40 in the FAQ:
http://support.microsoft.com/?kbid=282977

Pete

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
CERTIFIED EXPERT
Most Valuable Expert 2015
Distinguished Expert 2018

Commented:
Maybe this tool can help you:

http://www.trigeminal.com/lang/1033/utility.asp?ItemID=7#7

It's for A2000 but it might work for A2002 as well.

/gustav

Author

Commented:
I had to append all of the data into a new 'master' structure on my end.  All tables and indexes, keys, etc. existed in blank tables before I started and I had to append each table one at a time.  It didn't matter what I tried as far as importing into a new db, using the recommended tool, etc.  None of those methods would remove the reference fields to the replicated table.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.