Upsizing one table

[Guest]

I have an Access 2000 database that has 10 tables. I'm thinking about
upsizing one of the tables to MSDE and having it sit on a host file server.
The data in the nine other tables never change, so I'll keep those with the
client. Any suggestions re: this approach? The current database utilizes
DAO. Should I use ADO with regard to the MSDE table? Is is okay to include
DAO and ADO in the same client? Any recommendations about going in this
direction would be very helpful. Thanks.

Ken

 

[Douglas J. Steele]

There's no issue using both ADO and DAO in the same application, as long as
you're careful to disambiguate all declarations (i.e.: Use Dim rs As
DAO.Recordset or Dim rs As ADODB.Recordset, rather than simply Dim rs As
Recordset).

The list of objects with the same names in the 2 models (i.e.: those
declarations which need to be disambiguated) is Connection, Error, Errors,
Field, Fields, Parameter, Parameters, Property, Properties and Recordset

 

['69 Camaro]

Hi, Ken.

Should I use ADO with regard to the MSDE table? Is is okay to include
DAO and ADO in the same client?

To add to Doug's advice about disambiguating objects with the same name in the
two object models, there's a common belief that one should _only_ use one object
model or the other, but this belief is unfounded. The object models are not
exclusive. Both object models have many of the same capabilities, but each one
has capabilities that the other doesn't. If you've already written VBA code in
DAO that works, you shouldn't just rewrite it in ADO to "upgrade it." Unless
the alternate data access model has a clear advantage, rewriting for the sake of
rewriting is probably wasting your time, unless you need to build these skills
"right now."

That said, use SQL to manipulate data or alter table structures -- unless you
can't. In those cases, use ADO or DAO Recordsets, but those cases should be
rare. SQL statements will update data sets much faster than updating row-by-row
in a Recordset.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.