For smaller applications, JET is easier to use, often faster, easier to
develop with, has a more powerful expression service that can fully utilize
VBA functions, can be transported easily between machines. However:
It is in no way as secure as the MSDE. While both are rated at 2GB, JET
databases can comfortably hold less than half of that, while the MSDE can
hold it all, and then be scaled to a full version of SQL-Server.
I haven't run into any query batch limitations yet. The largest table I've
run a query on has been just over 800,000 records.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads: http://www.datastrat.com http://www.mvps.org/access
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
