Group:  Microsoft Access ยป microsoft.public.access.replication
Thread: Manually editing the conflict table

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Manually editing the conflict table
"David H" <dhowlett[ at ]laoh.ucla.edu> 11.07.2006 16:02:18
I am trying to get rid of a conflict error that won't go away. Forgive my
noviceness but how do I find the conflict table? I'm using Jet 4.0,
Microsoft Access 2000 Ver 9.0 Build 6620 SP 3.

Also, is it ok to just delete records in the conflict table? I have already
re-spawned replicas from the design master so there shouldn't be any real
conflicts.

-David




"David W. Fenton" <XXXusenet[ at ]dfenton.com.invalid> wrote in message
news:Xns97E9CA0B740f99a49ed1d0c49c5bbb2[ at ]127.0.0.1...
[Quoted Text]
> "David H" <dhowlett[ at ]laoh.ucla.edu> wrote in
> news:uYIsglVlGHA.4244[ at ]TK2MSFTNGP02.phx.gbl:
>
>> I synced the design master with one replica file, now it says I
>> have conflicts and would I like to resolve them. So I said 'yes'.
>> It displays the conflict resolver and shows that I have one table
>> and one record with conflicts. However, when I click 'view' it
>> gives an a pop-up error message and says it is unable to view or
>> resolve this error.
>
> I've you tried looking at the conflict table (or the error table, if
> it's Jet 3.5)?
>
>> I've tried everything I can think of to get around this and so far
>> no luck. I've tried Compact and Repair. I've tried making a copy
>> of the design master (so it is now just a replica) making it the
>> design master again, creating a brand new replica and syncing the
>> two. No luck.
>>
>> How do I clear this conflict?
>
> Well, look at the conflicts table directly. Find the record that
> won't display. Read what it says the problem is, resolve that
> problem and the error will go away.
>
> Yes, if you're thinking "that last is easier said than done" then
> you're right! :)
>
> --
> David W. Fenton http://www.dfenton.com/
> usenet at dfenton dot com http://www.dfenton.com/DFA/



Re: Manually editing the conflict table
"David W. Fenton" <XXXusenet[ at ]dfenton.com.invalid> 11.07.2006 23:25:13
"David H" <dhowlett[ at ]laoh.ucla.edu> wrote in
news:efnngLQpGHA.4960[ at ]TK2MSFTNGP04.phx.gbl:

[Quoted Text]
> I am trying to get rid of a conflict error that won't go away.
> Forgive my noviceness but how do I find the conflict table? I'm
> using Jet 4.0, Microsoft Access 2000 Ver 9.0 Build 6620 SP 3.

If you have a conflict in tblMyTable, the conflict table will be
called tblMyTable_Conflicts.

> Also, is it ok to just delete records in the conflict table? I
> have already re-spawned replicas from the design master so there
> shouldn't be any real conflicts.

You can delete records from the conflict table, yes.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Re: Manually editing the conflict table
"David H" <dhowlett[ at ]laoh.ucla.edu> 18.07.2006 18:56:07
Thanks for the help!

"David W. Fenton" <XXXusenet[ at ]dfenton.com.invalid> wrote in message
news:Xns97FDC58D96D47f99a49ed1d0c49c5bbb2[ at ]127.0.0.1...
[Quoted Text]
> "David H" <dhowlett[ at ]laoh.ucla.edu> wrote in
> news:efnngLQpGHA.4960[ at ]TK2MSFTNGP04.phx.gbl:
>
>> I am trying to get rid of a conflict error that won't go away.
>> Forgive my noviceness but how do I find the conflict table? I'm
>> using Jet 4.0, Microsoft Access 2000 Ver 9.0 Build 6620 SP 3.
>
> If you have a conflict in tblMyTable, the conflict table will be
> called tblMyTable_Conflicts.
>
>> Also, is it ok to just delete records in the conflict table? I
>> have already re-spawned replicas from the design master so there
>> shouldn't be any real conflicts.
>
> You can delete records from the conflict table, yes.
>
> --
> David W. Fenton http://www.dfenton.com/
> usenet at dfenton dot com http://www.dfenton.com/DFA/


Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net