Ac 2007 vs .NET

[uGek010]

Does anyone know if a client application developed in .NET that connects to
an Access 2007 back-end database is faster than an application developed with
Ac 07 for both the front-end interface and back-end component. In other words
an .accde as the front-end and an .accdb as the back-end. Your insights on
this matter are greatly appreciated.

Thanks,

 

[Michel Walsh]

Depends. You are probably to use ADONet to connect to the Jet database,
which is basically a kind of disconnected 'record' model. So, as example, if
you pump locally two tables of 1000 records each, then make the equivalent
of a cross join, locally, you save 1000*1000 records transmissions through
the wire that would have been transmitted with the query
"SELECT * FROM tableA, tableB"
with Access (using the said query). It is easy to see that you may save on
the repetition of some data. Sure, real life scenarios are less evidently
biased in favor of ADONet, and you may not see any real benefit at all. And
you can maybe reach the same speed using Access by carefully using WHERE
clauses and/or something else than the default DAO-dynaset recordsets, if
this is applicable in your case that is.

On the other hand, you are likely to have to write much more code with
ADONet directly, unless you use good tool such as MSDataSetGenerator, than
the same code you will need using Access (or the code generating tool).

So, it depends of your scenario, and the time you have (are allowed) to
invest.


Vanderghast, Access MVP