What is the general feeling of the group with respect to RDO vs ADO ? Here
is the issue, I am developing a system in VB 6.0 that will add a minimum of
150,000 records (x 180 bytes) per month. For some sites, I would like to
run under MSDE, the larger sites will run under MSSQL 7.0. By using MSDE, I
will be able to roll the smaller sites into SQL as they become larger. Are
there any big concerns going with ADO rather than RDO ? From what I have
read, ADO adds some overhead to the completed project, whereas RDO requires
less resources but requires a little more work on the programmer's side.
The completed system will have 12-15 users and, once the data is loaded in,
will primarily be doing look up queries.
I appreciate any insights the group may have and thanks in advance.