My two cents:
I deal with crucial data entry applications, which is basically
what you are doing. You are updating a database with crucial data.
You are using a Access database. This is what I do. Update the
database every transaction. If the power goes out, you have lost no
data that has been written to the database, worst case scenario you
might lose one transaction.
How you choose to do this, these other people know much more
about, I use DAO DATA1 control, which they have told me repeatedly to
stay away from. From what I understand, the biggest difference
between what I do and ADO is that with ADO you cannot create a new
database file. I don't think this is a problem for you.
[C]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/k7folB/TM
--------------------------------------------------------------------~->
'// =======================================================
Rules : http://ReliableAnswers.com/List/Rules.asp
Home : http://groups.yahoo.com/group/vbHelp/
=======================================================
Post : [EMAIL PROTECTED]
Join : [EMAIL PROTECTED]
Leave : [EMAIL PROTECTED]
'// =======================================================
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/vbhelp/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
