My company is looking for a new accounting package. We have been looking into a few packages written in VFP, so that I will be able to customize it.

I was disappointed to learn recently that only the SQL & MSDE versions of Accountmate will be marketed here in my country, by the Softline group. (The USA version is currently being customized for local VAT tax etc) The MSDE LAN version replaces the VFP table LAN version.

I have written a few small apps using VFP and VFP tables, and am very comfortable with it. However, I know nothing about programming with SQL/MSDE. I am not really a professional programmer, and would hate to go through the SQL learning curve.

All I can see is that MSDE would be a major learning curve. I would not be able to open tables, look at the data, add fields, create strings of commands, etc that I can presently do with VFP tables. I cannot visualize working “blindly” with MSDE tables, as opposed to the VFP database designer, where everything is graphical, where tables can be dragged onto forms as grids, etc. All my current knowledge of working with VFP tables would be lost.

I can understand that SQL/MSDE has more security, and is less likely to encounter corrupt files. But for a small company with a LAN of about 10 computers, where security is not really an issue, where a UPS can help prevent power outages, I cannot see the big advantage of MSDE over VFP tables.

If we were to grow to 20 or more users, VFP could easily handle the job, whereas with MSDE, the built in throttle would try to slow things down, in an attempt to get you to buy full SQL. SQL also seems to require constant administration. (Also, VFP only has 2 GB table limit, whereas MSDE has a 2 GB database limit.)

I would imagine that there are many LAN (and even WAN) applications out there that run on VFP tables, some of them with 100 or more users, that do not give any problems.

I see SQL/MSDE as a big clumsy expensive option, aimed at large organizations.
I see VFP tables as simple, flexible, easy to use, and free.

Aren’t VFP tables far easier and more flexible to work with than MSDE tables?

On a local area network, is security & possible file corruption that much of a problem with VFP tables?

Is it really necessary to replace VFP tables with MSDE tables in applications?

Will VFP 8.0 databases and tables have any added features, or will that be withheld to protect SQL?


Regards