Hi everybody,
a suggestion, please. I have an application A that modifies the
records of an access database. I should write an application B
(running on the same machine) that monitor these changes, without
modifying application A. I think the only solution is polling the
database and check every record in the table. I realized an
application that reload periodically in memory all the records (I use
an oledbdatareader, stayng always connected) and compares them with
the previous loaded records. Unfortunately the database is very
large
and this procedure takes 2s on a Pentium IV. Do you know any better
method or some tips I could use to improve the performances? I tried
using a dataset and working disconnected, but it's slower (3s).
Thanks.
Re: Individual vs.whole dB locks on forms/reports during modificat ...Fix access so that users can once again modify forms while ... like forms and reports while other users are in the database....Suggestion: Fix acesss so that users can once again modify reports while ... (microsoft.public.access.forms)
Re: End of File message, Outlook will not open ... and then I did a complex compact of the database and it restored my ... > Thanks for another suggestion.... > able to retrieve them, I will archive the old messages. ... >> protecting yourself from newsgroup spam.... (microsoft.public.internet.outlookexpress.mac)
Re: how to insert a row in existing table from within field code ... The first suggestion won't work well for me as I'm working from a CSV ... exported from an online database program, so I'd have to create a ... the current donor, or move on to the next donor. ... from my database for each donation, and really need a table format ... (microsoft.public.word.mailmerge.fields)
Re: Make an MS Access Recycle bin ... I don't think Access should be loaded with another automated feature that ... "Nick ''The Database Guy'' McMillen" ... This post is a suggestion for Microsoft, ... Agree" button in the message pane.... (microsoft.public.access.tablesdbdesign)
