Calendar - Odd Problem -- Data Provider Bug?

Print Page | Close Window

Odd Problem -- Data Provider Bug?

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=6752
Printed Date: 06 October 2024 at 1:13pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Odd Problem -- Data Provider Bug?

Posted By: rgracie
Subject: Odd Problem -- Data Provider Bug?
Date Posted: 28 March 2007 at 7:37pm

VBA Environment; AXP

2 Back End Databases; Main and Calendar.

I have a multi-resource schedule, using DAO to manipulate 1 extra field (RN) placed in the event table of the calendar database.

The problem:
If I persist a connection to the Event table in the calendar database, the calendar control takes forever to right to the table. Sometimes up to 30-40 seconds.

Example:
Set rstSXPLink = db.OpenRecordset("Event", dbOpenDynaset)

As soon as I close the recordset, which I don't want to do, the control writes to the table instantly.

I need to persist a DAO connection to the calendar db, as this significantly improves performance, and I need the control to write to the table as soon as .DataProvider.Save excutes, in order for my code to find the EventID and Place the linking number in RN. If the control has not written to it's table by the time my code looks, it fails to link.

Any idea??

Robert