Hi Craig,
It may vary. For Access 97 databases default engine is Jet (DAO), for Access 2000 databases - ADO and for Access 2000 project - SQL server. Access can make a good front tool.
Igor
>Technically, Access is a database application development tool. It's default database is Jet.
>
>>One thing for sure, Access is not a database engine (it is nothing then a sophisticated file sharing system) and will always be slower than SQL, Oracle and others.
>>
>>
>>>I heard that if using MS Access it reaches more then 24,000 records that it becomes less efficient or that databse will run slower. Is this true?
Igor Gelin
Database Developer