sharing/add data wiith ADO between VB6 and Excel?
From: PetitTrot (petit.galop_at_cowboy.ca)
Date: 08/31/04
- Previous message: FL: "Borland BDE engine+ADO+WinXP SP2"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 30 Aug 2004 23:07:30 -0400
Here I have a «mixed» program with VB6 and Excel
1) VB6 open an Excel Workbook
2) VB6 open an database and Excel open also the same database (local
database: MS Access 2000, use ADO)
3) VB6 run an Excel macro
4) this macro add data into database i.e. new record
5) after run Excel macro, VB6 continue
6) later VB read data - but new record, from step 4), is not accessible
My hypothese is: ADO add new data (record) «in memory» (RAM)
the command Update for recordset, not write
immediatly the new data in database
I search if possible force Excel write
immediatlly new data in database (flush memory)
Do you have comments?
- Previous message: FL: "Borland BDE engine+ADO+WinXP SP2"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
