Deleting a record


Hello,

I have an Access database that is handled only with SQL commands through ADO queries.

When I delete a record from the database, I need to read the table again in order to update a combobox. But just after the delete (SQL) command, it seems that the table is not updated yet and I get the deleted item on the combobox again.

If I wait a while and then read the table, the deleted record is gone and everthing is OK. But I do not want to wait to read the table.

Is there a way to refresh the Access table using a query?

Am I doing something wrong?

Thanks.
.

Relevant Pages

  • find a recordset in a dataset using a ComboBox
    ... I am accessing an Access Database with VB.net 2005 with ADO.net. ... placing an unbound ComboBox on the form ... When the user hits enter the form shows automatically the first Record ... Could anybody please enter some equivalent sample code for VB.NET ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Deleting a record
    ... I have an Access database that is handled only with SQL commands through ... Is there a way to refresh the Access table using a query? ... connection object ...
    (borland.public.delphi.database.ado)
  • LEFT JOIN sql query
    ... I am trying to populate a listbox from an access database using a left ... join based on the value in a combobox. ...
    (microsoft.public.excel.programming)
  • A problem with word vba
    ... I have created a table in access with 12 colums: ... I also created a form in WORD that calls the data from the access database ... with combobox and when I choose a value from the combobox - I update all the ... textboxes in my form accourding to the value I chose in the combobox. ...
    (microsoft.public.word.vba.customization)
  • Re: newbie: How to retreive string from ComboBox.SelectedItem?
    ... > If you added string objects to the 'Items' collection: ... The DataSource of the ComboBox is filled from a DataSet Table, ... from an Access database ...
    (microsoft.public.dotnet.framework.windowsforms.controls)