Re: Using ADO and DAO in same mdb



I like the response above.

There is no need to be worried about using dao and ado at the same
time.

You have to use dao to refresh the linked tables?

One can argue that ado is better, but dao seems to take less lines and
is simpler!

Sometimes you need ado to link to say dbII and SQL whilst most of the
time dao will be okay.

Having two developers is not an issue if they communicate okay plus
use similiar naming conventions.

One note though is be careful of binding forms with code if you can
just use linked tables!
You might as well use asp.net if you don't want to take advantage of
access's data binding.

I've seen nightmare coding with unbound forms when this wasn't
necessary.

Regards,
Tom Bizannes
Microsoft Access Development
Sydney, Australia
http://www.smartbiz.com.au

.



Relevant Pages

  • Re: How to enforce subtypes/supertypes in Access 2000?
    ... DAO is the native object model for Jet databases and, as such, is the ... ever need ADO. ... Private Sub SetContactType() ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Access 2007 and VB
    ... "unrecognized database format" ... There is a bit of confusion with ADO access to the new MSAccess ACCDB ... You could reference "DAO". ...
    (microsoft.public.vb.general.discussion)
  • Re: Access 2007 and VB
    ... and link to the download as a non expert some ... There is a bit of confusion with ADO access to the new MSAccess ACCDB ... You could reference "DAO". ...
    (microsoft.public.vb.general.discussion)
  • Re: Access 2007 and VB
    ... "unrecognized database format" ... There is a bit of confusion with ADO access to the new MSAccess ACCDB ... You could reference "DAO". ...
    (microsoft.public.vb.general.discussion)
  • Re: query mdb on network into Word. Access.exe not on workstation
    ... adodb provider for Jet did not know what to do. ... not sure that ADO uses DAO. ... >>> have ADO 2.8 because it was installed with the Office installation. ...
    (microsoft.public.access.externaldata)