http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 12 Jun 2026 23:11:07 +0000 Sun, 02 Mar 2008 10:39:51 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=9752 http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ http://forum.codejock.com/forum_posts.asp?TID=9752&PID=31822&title=sync-ms-access-database#31822 Author: delproposto
Subject: 9752
Posted: 02 March 2008 at 10:39am

Additional information.................
The Database Fields

Of Event (Table)
EventID (Field)
RecurrencePatternID (Field)

and
Of RecurrencePattern (Table)
RecurrencePatternID(Field)
MasterEvent(Field)

Are getting messed up.

In particular RecurrencePatternID (Event) and RecurrencePatternID (RecurrencePatternTable) sometimes don't match resulting in corrupted event.

Any ideas
Database is MS Access
Dan



]]> Sun, 02 Mar 2008 10:39:51 +0000 http://forum.codejock.com/forum_posts.asp?TID=9752&PID=31822&title=sync-ms-access-database#31822 http://forum.codejock.com/forum_posts.asp?TID=9752&PID=31794&title=sync-ms-access-database#31794 Author: delproposto
Subject: 9752
Posted: 01 March 2008 at 7:32am

I am using the sample Calendar Code (VB) and have incorporated it into my Visual Basic 6 Project which uses MS Access database to share another msaccess database. I am corrupting the MSACCESS database that Calendar uses when I try syncing the database with replica copy

I have tried closing the Calendar data connection figuring that I was creating a conflict but no luck. I use...

Data1.Database.Synchronize (PathToBackupCalendarDatabase)

The problem is corruption of the Calendar's database. The error start to appear in new EVENTS created in the RecurrenceID field.

Any Ideas? Should I be using another method with this database?

Thanks
Dan

]]> Sat, 01 Mar 2008 07:32:01 +0000 http://forum.codejock.com/forum_posts.asp?TID=9752&PID=31794&title=sync-ms-access-database#31794