Calendar - Sync MS Access Database

Print Page | Close Window

Sync MS Access Database

Printed From: Codejock Forums
Category: Codejock Products
Forum Name: Calendar
Forum Description: Topics Related to Codejock Calendar
URL: http://forum.codejock.com/forum_posts.asp?TID=9752
Printed Date: 22 May 2024 at 4:02pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Sync MS Access Database

Posted By: delproposto
Subject: Sync MS Access Database
Date 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

Replies:

Posted By: delproposto
Date 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