Turning off Replication

[mattcottrell]

We have an Access 2002 database which has been setup for replication.

Does anyone know how to turn off replication for the database or any other way to delete the fields automaticaly created in each table by the replication process.

Many thanks in advance.
Matt Cottrell

 

[treznorhk]

See this thread.

Doesnt look like it's going to be pretty.

thread181-446064

Zachary Mackay
Mackay Photography, Inc

http://www.mackayphoto.com

 

[treznorhk]

I found a quick way to do this with access 2002 (xp).

I created a new blank db, then i just did the "get external data", import function, and selected everything.

It pulled it all in and everything works!

There are a few extra fields in the tables left over from the replication that i can't delete, but recreating the table by hand would fix it, except in my case, I have over 200 fields in one table, so i'm just ignoring them for now.

-zach

Zachary Mackay
Mackay Photography, Inc

http://www.mackayphoto.com