JC:
Access, at least using the Jet Engine, was not written for, nor does it
support SMP in data processing. To take advantage of that, you've got to
move to a CS db backend like SQL Server and use that engine for the
processing power rather including moving things like VBA functions that
relate to data manipulation into the Server's engine where possible using
UDFs, Stored proceedures etc. rather than doing manipulation in the front
end of the db. The MSDE engine comes with Access, which is sort of SQL
Server lite, use's primarily the same kernel, but has a "governor" built in
that starts to degrade performance when more than 5 concurrent user's are
hitting against the engine.
