http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 30 May 2026 07:23:32 +0000 Wed, 28 Mar 2007 19:37:22 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=6752 http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ http://forum.codejock.com/forum_posts.asp?TID=6752&PID=21534&title=odd-problem-data-provider-bug#21534 Author: rgracie
Subject: 6752
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


]]> Wed, 28 Mar 2007 19:37:22 +0000 http://forum.codejock.com/forum_posts.asp?TID=6752&PID=21534&title=odd-problem-data-provider-bug#21534