MS Access and recurrent events

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

   I'm using V10.3.1 of the ActiveX CalendarControl from within MS Access but based on a SQL Server 2000 database. In other words, the MS Access application is just a front-end for the SQL DB. I have managed to get the Calendar working on the SQL Server backend via a custom dataprovider based on the VB sample. Everything works fine as far as non-recurrent events are concerned. Recurrent events are also stored correctly in the database but there seems to be a problem when retrieving these events.

Although I use the custom properties method in my CreateEventFromRS routine, the master event does not appear to be created correctly. I have debugged the entire data provider and everything seems to be working OK (DoReadPattern gets called to read the pattern and the exceptions for the master event, etc.). Also, the dataprovider is called to create all the occurences of the given recurrence pattern. However, when, later on I try to access the recurence pattern for any given occurence (e.g. to find the master event) I find that it is not there.
I get the feeling that the event and the recurrence pattern is read correctly by the data provider but they are somehow not tied together properly by the control itself (i.e. by the hidde/common part of the DataProvider).

Does anybody have any ideas?

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Erwin Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 22 November 2006 Status: Offline Points: 1	Post Options Post Reply Quote Erwin Report Post Thanks(0) Quote Reply Topic: MS Access and recurrent events Posted: 22 November 2006 at 4:32am
	I'm using V10.3.1 of the ActiveX CalendarControl from within MS Access but based on a SQL Server 2000 database. In other words, the MS Access application is just a front-end for the SQL DB. I have managed to get the Calendar working on the SQL Server backend via a custom dataprovider based on the VB sample. Everything works fine as far as non-recurrent events are concerned. Recurrent events are also stored correctly in the database but there seems to be a problem when retrieving these events. Although I use the custom properties method in my CreateEventFromRS routine, the master event does not appear to be created correctly. I have debugged the entire data provider and everything seems to be working OK (DoReadPattern gets called to read the pattern and the exceptions for the master event, etc.). Also, the dataprovider is called to create all the occurences of the given recurrence pattern. However, when, later on I try to access the recurence pattern for any given occurence (e.g. to find the master event) I find that it is not there. I get the feeling that the event and the recurrence pattern is read correctly by the data provider but they are somehow not tied together properly by the control itself (i.e. by the hidde/common part of the DataProvider). Does anybody have any ideas?
	WBR, Erwin

dangier Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 10 January 2007 Status: Offline Points: 13	Post Options Post Reply Quote dangier Report Post Thanks(0) Quote Reply Posted: 18 January 2008 at 10:37am
	Hi Erwin, I have a similar environment -- SQL Server backend and MS Access frontend. Also, most of the events are Master events with an associated recurrence. At this time, only the exceptions show up on the calendar--not the master events (recurrencestate = 1). Would you mind sharing what you found as a solution?