>I need a few good reasons why Visual FoxPro is better than MS Access.
>Can anyone help?
Yup, b/c Access is a piece of s.... oops, sorry, where's my etiquette?
Access is a great business tool for a non-developer for developing a simple database. The problems with it are simple:
1. One file (MDB) is the whole shabang: data, forms, queries, reports. It gets corrupted and good luck.
2. If you're at all accustomed to the power and flexibility of VFP, you'll soon be tearing your hair out and saying "I don't get it, this is EASY in FoxPro!"
3. It's search engine is slow. I mean, really, really slow.
On the other hand:
1. Just about anyone can create reports, forms, queries in Access without risking serious damage to data. Everything is point and click, virtually no programming, at least with code.
2. Access is more 'seamless' with the other Office applications, (97, anyway. previous versions were kind of cranky)
3. Development is quick. It's hard to create a bug. (but not impossible)
I still hate it, but I'm sure one of these days, I'll need it for something.
HTH
Matt McDonnell
...building a better mousetrap with moldy cheese...