Visual Fox Pro vs MS Access 
Author Message
 Visual Fox Pro vs MS Access

I've got a system written in FilePro (DOS) that tracks customers, orders,
etc.  I've got about 300K clients and 1 million transactions (that I
regularly have to search through).  It does things like interace with
an external credit card processing system, generate mailing lists, etc.

Recently, I read a glowing review of Visual Fox Pro, which led me to
think this might be a good place to go with my system.  I'm wondering,
though, could I just do it in Access?  Why would I use VFP over Access?
For that matter, why would I use *anything*?

What would YOU use?

Thanks



Wed, 23 Jul 1997 00:46:51 GMT
 Visual Fox Pro vs MS Access

: Recently, I read a glowing review of Visual Fox Pro, which led me to
: think this might be a good place to go with my system.  I'm wondering,
: though, could I just do it in Access?  Why would I use VFP over Access?
: For that matter, why would I use *anything*?

: What would YOU use?

FWIW,

Well FoxPro for Windows keep the Command Line prompt that you are
probably used to using.  In addidtion of there are .PRG file you use with
your current databse they will run under Foxpro for Widows.

Access will rad the database files and convet them MS-Access.  Access can
has a more advanced programming language but it takes time getting used
to if you are a old fashoned "Dos" person.

Access appears to be the way everything is headed.

Ron



Wed, 23 Jul 1997 01:02:04 GMT
 Visual Fox Pro vs MS Access

Quote:

>I've got a system written in FilePro (DOS) that tracks customers, orders,
>etc.  I've got about 300K clients and 1 million transactions (that I
>regularly have to search through).  It does things like interace with
>an external credit card processing system, generate mailing lists, etc.

>Recently, I read a glowing review of Visual Fox Pro, which led me to
>think this might be a good place to go with my system.  I'm wondering,
>though, could I just do it in Access?  Why would I use VFP over Access?
>For that matter, why would I use *anything*?

>What would YOU use?

>Thanks

Access is in no way meant to handle these size files. Access is very slow on these files
and has a tendency to corrupt. Fox can handle these tables with ease however...I ran some
tests here at SHL where Fox queried a million record table in .11 seconds! It is very stable
also. That is why it was used to perform the logistics for Desert Storm and it also managaed
over 100 gigs of data for the Eurotunnel project....

Visual Fox will blow any other DB away.. Been seeing many demos of beta version. Incredible!




Wed, 23 Jul 1997 04:15:24 GMT
 Visual Fox Pro vs MS Access
:>
:> I've got a system written in FilePro (DOS) that tracks customers, orders,
:> etc.  I've got about 300K clients and 1 million transactions (that I
:> regularly have to search through).  It does things like interace with
:> an external credit card processing system, generate mailing lists, etc.
:>
:> Recently, I read a glowing review of Visual Fox Pro, which led me to
:> think this might be a good place to go with my system.  I'm wondering,
:> though, could I just do it in Access?  Why would I use VFP over Access?
:> For that matter, why would I use *anything*?
:>
:> What would YOU use?

Quote:
>...

Why are YOU even asking? What is it that prompts the question? I would start with your
apparent disatisfaction.

I have no way of quantifying transactions per unit time etc. from the information you
provided. Could be that FoxPro is the the only answer given certain
constraints.

I use current versions of both and in general, find Foxpro quicker and
Access more convenient.

Bob



Wed, 23 Jul 1997 05:07:13 GMT
 Visual Fox Pro vs MS Access

Quote:
>>I've got a system written in FilePro (DOS) that tracks customers, orders,
>>etc.  I've got about 300K clients and 1 million transactions (that I
>>regularly have to search through).  It does things like interace with
>>an external credit card processing system, generate mailing lists, etc.
>Access is in no way meant to handle these size files. Access is very slow on these files
>and has a tendency to corrupt. Fox can handle these tables with ease
>however...

I am aware of the size limitations on Access; we are used it in the early
phase of an ODBC project because it is very convenient.  We plan to upscale to
some other DBMS before we start widely testing our product (this means soon).

I keep reading about Access vs. FoxPro.  I'd like to read some opinions on
FoxPro vs. MS SQL Server.

Bill Schwab
University of Florida
Department of Anesthesiology



Fri, 25 Jul 1997 17:55:37 GMT
 Visual Fox Pro vs MS Access
 >> Recently, I read a glowing review of Visual Fox Pro, which led me to
 >> think this might be a good place to go with my system.  I'm wondering,
 >> though, could I just do it in Access?  Why would I use VFP over Access?
 >> For that matter, why would I use *anything*?

I'll give you a good reason you _won't_ be using Visual Foxpro. It isn't
shipping! :-)

If you want a microcomputer DBMS for Windows database application
development, dBASE for Windows is superior to anything else available. The
fact that Microsoft doesn't own it is icing.

*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*

*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*



Sat, 26 Jul 1997 13:44:46 GMT
 Visual Fox Pro vs MS Access

...
...>

Quote:
>Visual Fox will blow any other DB away.. Been seeing many demos of beta version. Incredible!



I have used both FoxPro for DOS 2.5 and Fox Pro Win 2.6.
I haven't heard much about Visual FoxPro, yet.
Could someone tell some facts about this version; main advantages and new features.
Is it worth for waiting and when it will be available???
Thanks.



Tue, 29 Jul 1997 21:20:06 GMT
 Visual Fox Pro vs MS Access
Quote:
 Esa Laitila writes:

 >> I haven't heard much about Visual FoxPro, yet.

Get dBASE for Windows, instead. It's shipping now. It is more technically
advanced than FPWin, and will continue to leapfrog FP.

Best of all, Microsoft doesn't own it!!

*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*

*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*



Thu, 31 Jul 1997 01:17:39 GMT
 Visual Fox Pro vs MS Access


:>
Quote:
:> Esa Laitila writes:

:> >> I haven't heard much about Visual FoxPro, yet.
:>
:>Get dBASE for Windows, instead. It's shipping now. It is more technica
:>lly
:>advanced than FPWin, and will continue to leapfrog FP.
:>
:>Best of all, Microsoft doesn't own it!!
:>

I strongly disagree. FoxPro for windows is already more capable in most
respects and is considreably quicker as well. Where dBASE 5 has an edge
in in the programming of oo stuff. Personally, I would ask others in a
more objective position.

--
Cheers,
Bob    (http://www.trystero.com/kirwaido.html)
__________________________________________________
``If Nicole Simpson had owned a handgun, she'd be a wealthy widow
today...''



Thu, 31 Jul 1997 04:28:46 GMT
 Visual Fox Pro vs MS Access



: :>Get dBASE for Windows, instead. It's shipping now. It is more technica
: :>lly : :>advanced than FPWin, and will continue to leapfrog FP.

: I strongly disagree. FoxPro for windows is already more capable in most

FoxPro for Windows is NOT more capable than dBase.  It may have more
third-party support, but that's due to its longer presence on the market
and the Microsoft marketting muscle.

: respects and is considreably quicker as well. Where dBASE 5 has an edge
: in in the programming of oo stuff.

Agreed on both.

: Personally, I would ask others in a : more objective position.

Sounds good to me.  While I am a Borland fan, I don't bash Microsoft just
for the sake of bashing.

--
+============================================================================+

|| Pretty good Paradox for Windows Programmer, self-proclaimed Treknologist ||
|| [  the rest of this sig is under construction until further notice...  ] ||
+============================================================================+



Thu, 31 Jul 1997 05:14:42 GMT
 
 [ 10 post ] 

 Relevant Pages 

1. Visual Basic vs. Visual Fox Pro

2. Visual Basic vs. Visual Fox Pro

3. VB vs Access vs Visual Fox.

4. q. re:SQL Server vs Visual Fox Pro

5. SQL Server vs Visual Fox Pro

6. MS Visual Fox Pro (Personal Opinion Poll)

7. Visual Fox Pro and Access

8. Access?VB?Visual Fox Pro?

9. FOX Pro - Accessing via Visual Basic v4.0 Professional 16-bit

10. Access to informix OnLine WGS 7.2.UC2 from Win95 Visual Fox Pro 5.0

11. Accessing Visual Fox Pro table

12. Access CLIPPER files from Visual fox Pro???


 
Powered by phpBB® Forum Software