Re: ADO recordset doesn't see DB changes



Neil B wrote:
This is the call to the method in my CDataBase class that opens the
database:

bDB.Open("Microsoft.Jet.OLEDB.4.0", m_newBooks, "935290346", "Books");



OK, you are probably running into the Jet delayed-write optimization.
See here for how to deal with it:

http://support.microsoft.com/?kbid=240317
http://support.microsoft.com/kb/200300
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.



Relevant Pages

  • Re: Spltting large datasets for parallel processing
    ... Microsoft MVP ... Please reply only to the newsgroup so that others can benefit. ... The processing is essentially, pick up all messages from the database, ... 1,000,000 messages and processing at a maximum in batches of 250. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: How to read and write a word-document from a database
    ... This posting is provided "AS IS" with no warranties, ... When I try to I get the byte array from the database and store it ... >> Microsoft MVP ... >> Please reply only to the newsgroup so that others can benefit. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: connection string format
    ... format to use to talk to an Oracle 10g database without a DSN. ... Microsoft MVP -- ASP/ASP.NET ... Please reply to the newsgroup. ...
    (microsoft.public.data.ado)
  • Re: Large DataSet Question
    ... database grows. ... I am trying to design it with the future in mind! ... > Microsoft MVP ... > Please reply only to the newsgroup so that others can benefit. ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Restore public folders and companyweb
    ... Thank you for posting in the SBS newsgroup. ... I understand that the Public Folder Store ... database cannot be mounted due to integrity problems, ...
    (microsoft.public.windows.server.sbs)