Does MS Access 2002 take advantage of Dual Xeon processors?

[Dan V.]

Does MS Access 2002 take advantage of Dual Xeon processors?

 

[aaron.kempf]

gosh.. that's a tough question.

in short; yes it does.
especially if you're using Access Data Projects against a local MSDE
install.

-Aaron

 

[Dan V.]

We are not using MSDE. How much of an advantage for speed is MSDE?

How much of an advantage (in percentage) is dual compared to single
processor for MS Access. Hazard an estimate? Our application is a
multi-table select query.

We are using ASP.NET and IIS and MS Access 2002.

thanks,

 

[Douglas J Steele]

Sorry, in that case you aren't using Access: you're using ADO.Net to read a
Jet database. I believe you'll find that Access (i.e. msaccess.exe) is not
running while your application is running. In actual fact, there's no need
to have Access installed on the server.

AFAIK, msaccess.exe can't take advantage of dual processors. I would assume
that ASP.Net and IIS can, but can't comment whether that would make any
difference in your scenario.

 

[aaron.kempf]

you should be using MSDE it is the same price as MDB but it's a lot
better, more reliable.. faster.. much more powerful transactions.

do you host something internally or do you buy rackspace or something?

-aaron