B
bubs719-dd
I'm developing a few forms in an Access database (call it database1)
which also needs to access data held in a separate mdb file (call this
database2) and I'm using VBA and ADO to read/write the data in
database2. This is working fine. On the forms I have some list boxes
whose record source is in database2. I've got these to access the data
by setting up a linked table in database1 and pointing it to database2
(couldn't think of a better way). The problem I'm having is that when
the forms update data in database2 (using an ADO recordset), I do a
REQUERY on the list box and the changes do not come through. I've tried
COMMITing the ADO UPDATE but no luck. If I put in a delay of a few
seconds before doing the requery the changes do come through.
I'm using Access 2003 SP1.
Anybody got any ideas?
Thanks
Nigel
which also needs to access data held in a separate mdb file (call this
database2) and I'm using VBA and ADO to read/write the data in
database2. This is working fine. On the forms I have some list boxes
whose record source is in database2. I've got these to access the data
by setting up a linked table in database1 and pointing it to database2
(couldn't think of a better way). The problem I'm having is that when
the forms update data in database2 (using an ADO recordset), I do a
REQUERY on the list box and the changes do not come through. I've tried
COMMITing the ADO UPDATE but no luck. If I put in a delay of a few
seconds before doing the requery the changes do come through.
I'm using Access 2003 SP1.
Anybody got any ideas?
Thanks
Nigel