Minggu, 02 September 2012

[MS_AccessPros] Table actualizing slowly

 

Hi, I'm newbie in MsAccess not in programming
I have a doubt about an Access form where I'm adding, modifying an deleting records of a table with independent textboxes and ADO methods.
Below these textboxes and buttons I have a subform with a query of the same table (with restrictions). Every time I acualize the table with ADO method, I do a subform requery.
All is running ok but for instance I have no records in subform, and I add a record, it doesn't appear in subform after five or six seconds (I'm .requering the subform), the second record I add appears in 3 seconds and other modification or addings appears inmediatly in subform.
It seems like ADO methods and subform actualization with recordsource took different ways.
Anybody knows something about this effect? It's a little annoying effect
Thanks in advance
Best regards

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar