>What is the main difference between VFP and Ms Access. I know that Ms Access is similar to VB which had capability to do whatever VFP can do , but why people preferred VFP over Ms Access??

MS Access is quazi-VB with obvious limitations in data and code handling.