Codejock Forums Homepage
Forum Home Forum Home > Codejock Products > Visual C++ MFC > Calendar
  New Posts New Posts RSS Feed - Sync MS Access Database
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Sync MS Access Database

 Post Reply Post Reply
Author
Message
delproposto View Drop Down
Newbie
Newbie


Joined: 01 March 2008
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote delproposto Quote  Post ReplyReply Direct Link To This Post 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

Back to Top
delproposto View Drop Down
Newbie
Newbie


Joined: 01 March 2008
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote delproposto Quote  Post ReplyReply Direct Link To This Post 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



Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.141 seconds.