Solved

Foxpro Benefits?

Posted on 2001-08-14
7
484 Views
Last Modified: 2008-03-06
Hello experts!  I have a question that has been bugging me a little bit lately.  What are the benefits of Foxpro when compared to Access?  Any information that you can provide would be greatly appreciated.  Thanks in advance. --Ren
0
Comment
Question by:Ren
  • 3
  • 2
  • 2
7 Comments
 
LVL 43

Expert Comment

by:TimCottee
Comment Utility
In what respect? Foxpro Dos or Visual Foxpro? As a development environment or as a database backend?
0
 
LVL 5

Expert Comment

by:rkot2000
Comment Utility
for the record i am not using foxpro and i am trying to avoid ms access.
For small projects we are using msde
http://msdn.microsoft.com/vstudio/msde/default.asp

but i found this on mircosoft :

http://msdn.microsoft.com/vfoxpro/prodinfo/qa.asp

How do you position Visual FoxPro in relation to Microsoft Access?

Microsoft Access, the database in Office, is the most broadly used and easiest-to-learn database tool that Microsoft offers. If you are new to databases, if you are building applications that take advantage of Office, or if you want an interactive product with plenty of convenience, then choose Access. Visual FoxPro is a powerful rapid application development (RAD) tool for creating relational database applications. If you are a database developer who builds applications for a living and you want ultimate speed and power, then choose Visual FoxPro.  

0
 

Author Comment

by:Ren
Comment Utility
Well, actually I am a beginning software developer who works for a financial research firm (I have a Master's of Finance, but no true programming credentials).  Since I have an interest in programming, I have been asked to create a program that will access large databases (A foreseeable maximum of 500 fields and 100,000 records) contained on the CD, and I was wondering what my optimal choice would be.  
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:Ren
Comment Utility
Oh, I forgot, the program will be created in VB, and it will simply access the database.  
0
 
LVL 5

Expert Comment

by:rkot2000
Comment Utility
Single user or multi-user environment?
0
 
LVL 43

Accepted Solution

by:
TimCottee earned 25 total points
Comment Utility
That is a key question rkot2000, for an access database on a CD, you MUST use exclusive read-only access as it will otherwise create the .ldb locking file in the same folder as the database. For a CD based application this is impossible as you cannot write to a read-only medium. For a foxpro database this is not a restriction provided of course that you do not want to write any data which is impossible on a CD. Both access and foxpro should be able to cope with the number of records that you suggest, there are maximum field restrictions:

Foxpro: A single table can contain up to 255 fields. If one or more fields allow null values, the limit is reduced by one to 254 fields.

I am not sure if there is a limit in access but you should check this. Of course you can get around this by splitting the table into two and defining a one to one link between them. This will have the effect of creating a single table with > 255 fields.
0
 

Author Comment

by:Ren
Comment Utility
Thanks!  --Ren
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…

763 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

9 Experts available now in Live!

Get 1:1 Help Now