[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 903
  • Last Modified:

FoxPro vs Access

What 's the difference between FoxPro and Access???
When'll we use FoxPro and when 'll we use Access to deal with data base ???
Why do Microsoft produce FoxPro and Access which manipulate database at the same time???
If FoxPro is the graphic front end, then what 's the diffence of writing database application in VC++ and FoxPro ??? Which is better ???
0
surenechan
Asked:
surenechan
1 Solution
 
EdithfCommented:
Try to separate the questions
0
 
MorFFCommented:
surenechan,

Firstly Access and FoxPro both have graphic front ends.

Next Microsoft sell FoxPro because they bought over the conpany that created it and have kindly agreed to continue the support of the product (for how long is anyones guess ;-) )

Next VC++ is a programming language as opposed to a Database package.  As such you will need to be operating at a much lower level if you want to manipulate data with VC++ (you also have much more control over what you can do tho')

What it comes down to is what you want to do.  If you've not got a database and are starting from scratch, with little experience, prolly best choose Access.  If you want to do fancy stuff in data manipulation and have time to learn VC++ then go for that.

Hope this Helps - MorFF
0
 
surenechanAuthor Commented:
Well, actually I'm going to write a simple database window application which does not involve client/server.

-Is it the graphical user interface of Visual FoxPro or MS Access is good enough so that there is no need to use VC++ ?

-Access and FoxPro, which is more powerful ?
0
 
jonestCommented:
I've noticed that ACCESS seems to be a little slower in loading up record information (usually do to filters being set on unindexed fields).  FoxPro takes a little longer to get a grasp of but with the improvements made by Microsoft to go to a more "Visual" development suite, the learning curve is rather steep.

The form design is object oriented so much so that the GUI is rather easy to create.  You can start with a Wizard that will develop most of your forms - you don't even have to do any coding.  You can then manipulate these wizard forms with drag and drop approaches.  It is quite similar to form design in Visual Basic and I assume VC++.

I guess the short answer is YES.  I have yet to add any VC++ code to a form to do any GUI manipulation - I've had to add it to do some file preparation for third party add ins.
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now