What is faster .mde or automation?

[Martin]

If i use vb automation to run access will it be faster
than an .mde? Does it have any other advantages or
disadvantages?

Thanks
Martin

 

[chas]

Hi,

automation is the process of using code to work with a COM
application. An .MDE is a type of file that you can
create in Access to hide code and prevent design changes.

hth

chas

 

[david epsom dot com dot au]

Also, from VB, a lot of what you want to do is done
faster and better using ADO automation, not Access
Automation.

ADO = active data objects. If you only want to
deal with data, set a reference to ADO in your
VB project, and use ADO instead of Access.

(david)