Sync MS Access Database

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   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

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
delproposto Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 01 March 2008 Status: Offline Points: 2	Post Options Post Reply Quote delproposto Report Post Thanks(0) Quote Reply Topic: Sync MS Access Database 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

delproposto Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 01 March 2008 Status: Offline Points: 2	Post Options Post Reply Quote delproposto Report Post Thanks(0) Quote Reply 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