ODBC, VB, [Data Control | ADO Data Control] -- I need to connect and release when requested.
Posted on 2004-08-11
My data control hogs up access to the FoxPro database (through ODBC) and prevents my program from Zapping the records.
I am making an ActiveX Calendar Control.
Here is the order of operations
User clicks the Tab in FoxPro.
FoxPro USE EXCLUSIVE's the Calendar table, Clears it. Loads it with real data. Then tells the calendar to REFRESH based on the new data.
Everything works, except i get an error telling me that fox cant use the database exclusive because the control has a finger in it.
How can i (programically) create the connection?
I'm using a Data Control (vb6) and have been told to switch to ADO data control.
I DO NOT WANT TO SET THE CONNECTION THROUGH THE PROPERTY WINDOW BECAUSE I NEED TO START AND STOP IT VIA CODE.
Cheers, It's important : ) So answer quickly