ADODataSet Refresh Problem

From: Ryan Schoolman (ryan_at_infinitejoy.com)
Date: 03/22/04 

Date: Mon, 22 Mar 2004 10:04:58 -0600

Hi I'm using an Access 2000 database and I'm having a problem with a Table
that when I call the Refresh method after putting the dataset in insert mode
it likes to hang for a bit and then continues. I have no OnCalc events and
if I don't call the refresh method 

-- 
Ryan Schoolman - Programmer & Application Architect
ryan@infinitejoy.com
Infinity Software Solutions Inc.
http://www.infinitejoy.com
[w] 715.839.6855
[c] 715.379.0878
[h] 715.855.9003

Relevant Pages

  • Re: A little help with access forms.
    ... The refresh method will not show new records that you add, ... I use views all the time to sql server. ... server, make into a view, and then you link to that view from ms-access. ... since your database engine is now sql ...
    (microsoft.public.access.conversion)
  • Re: New record problem in sub-form
    ... The Refresh method shows only changes made to records in the current set. ... Since the Refresh method doesn't actually requery the database, ... data in the record source. ...
    (microsoft.public.access.forms)
  • Re: How can i delete a record?
    ... Since the Refresh method doesn't actually requery the database, the current set won't include records that have been added or exclude records that have been deleted since the database was last requeried. ... When the record source for a form is requeried, the current set of records will accurately reflect all data in the record source. ...
    (comp.databases.ms-access)
  • Re: Form refresh
    ... "The Refresh method immediately updates the records in the underlying record ... The Refresh method shows only changes made to records in the current set. ... Since the Refresh method doesn't actually requery the database, ... environment, and that even there it is of limited use. ...
    (microsoft.public.access.forms)