Rgiraldo said:
whats the best to use jet database engine or desktop engine, and whats the
query batch limmitations? Thank you for your time
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
