Solved

FoxPro vs Access

Posted on 1998-05-10
4
785 Views
Last Modified: 2006-11-17
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
Comment
Question by:surenechan
4 Comments
 
LVL 1

Expert Comment

by:Edithf
Comment Utility
Try to separate the questions
0
 
LVL 3

Accepted Solution

by:
MorFF earned 10 total points
Comment Utility
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
 

Author Comment

by:surenechan
Comment Utility
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
 

Expert Comment

by:jonest
Comment Utility
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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now