Re: Deleting a record


"Paulo Hoffmann" <p@xxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:47cd5f3c$1@xxxxxxxxxxxxxxxxxxxxxxxxx

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?
Actually you do. Probably yours dataset and query don't share same
connection object (please note: object, but not connection string). Thus you
have to deal with Jet Latency problem. Also in this specific case it would
be easier and more efficient also to do it through dataset.delete.


.

Relevant Pages

  • Re: error messages when connecting to an MS Access query
    ... I'm actually opening the Word document from VBA in the Access database, ... It's actually easy to run a Make Table query in Access, ... I got messages saying it couldn't make the connection. ... When you try to make a DDE connection, if the database is not already ...
    (microsoft.public.word.mailmerge.fields)
  • RE: ODBCDirect Workspace
    ... successfully ported my tables to SQL Server and have created an Access ... Are you using one Access database to work inside of another Access database? ... Set daoDbs = Nothing ... However if you are going to be using this query again to populate the combo ...
    (microsoft.public.access.modulesdaovba)
  • RE: ODBCDirect Workspace
    ... successfully ported my tables to SQL Server and have created an Access ... Are you using one Access database to work inside of another Access database? ... Dim strSql As String ... However if you are going to be using this query again to populate the combo ...
    (microsoft.public.access.modulesdaovba)
  • Re: Help with TableAdapter
    ... FROM ((((ReportedWeeds LEFT OUTER JOIN ... the sql into the Access database from the TableAdapter, ... Access database for any particular query? ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Do I understand form optimization correctly?
    ... queries on an Access database. ... Access is file based, not server based. ... If you run any query on the table, the entire table is brought down to ...
    (comp.databases.ms-access)