The performance starts to degrade when the table has 200000+ records wheras VFP starts to shine there onwards.
Moreover, this is a VFP forum, access is supposed to be BASHED here :-)
Mohinder

>>The speed is still the same. I have plenty of disk space available (200MB). The funny thing is that Access if giving a better performance than VFP whereas I have seen a lot of Access bashing on this site.
>
>If you read the 'Selecting a DataBase Devlopement Tool' or such on Microsofts site.. I belive it was written by Robert Green, it talks about the speed of the FoxPro engine vs the Access engine...
>
>Bottom line is... the Access engine has been very FIXED with FoxPro code.. it contains rushmore optimization... it also contains some of the MS-SQl methods which has to do with multi-user performance and adding multi-records... basically, multi entry points were created so page lociking would not slow down record adding.
>
>Anyway... the bottom bottom line is that VFP and Access (Jet 3.0 I think) are so close in performance that there is little difference.
>
>The main differences are structure, record locking vs page locking, and security.
>
>Most people here that Access bash are relying on 4-6 year old Jet engine info.
>
>BOb