By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,799 Members | 1,345 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,799 IT Pros & Developers. It's quick & easy.

foxpro compared to access......can they do the same thing

P: n/a
All we are hearing at work now is we should give up on access.

NO NO NO you need to go with foxpro.

access is dead and can't do anything compared to foxpro

It can make coffee, and forward your email....bla bla bla

to the people who have used both...what do you say to these people.
who have never used or programmed in either one.
Just what they read or hear.

thanks big time for any help

bty it all started when someone told them that foxpro can do to
databases at the same time and compare entries
being input and warn the data entry person of comparison errors
between what they are typing and what has already been entered.

thanks again

jerry
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies

P: n/a
sparks <sp****@here.com> wrote in
news:gf********************************@4ax.com:
All we are hearing at work now is we should give up on access.

NO NO NO you need to go with foxpro.

access is dead and can't do anything compared to foxpro

It can make coffee, and forward your email....bla bla bla

to the people who have used both...what do you say to these people.
who have never used or programmed in either one.


It's true; everyone should go to FoxPro except me! I should stay with
Access. And then we could see if I could compete. Me and Access versus The
World and FoxPro. We could hold the match in a big stadium and have it on
TV as Pay-per-View. One of those big boobed Amazons could be running around
outside the ring doing dirty tricks (She'd be called "Fox Pro" of course.)
..... Well, sounds a hell of a lot more civilized than much of the crap
appearing here lately ... doesn't it?

OR

You could dust off the old brain (there IS a brain, isn't there?) and ask
some sensible question.

--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)
Nov 12 '05 #2

P: n/a
"sparks" wrote
All we are hearing at work now
is we should give up on access.

NO NO NO you need to go with foxpro.


Visual Fox Pro is a good database for those who want to program; it's not a
good database for those who just want to use a database. Access is good for
either, and if you are a developer, the development effort is significantly
faster using Access for a comparable application.

The Jet database engine is on its way to being "dead" but the
code-nameLonghorn version of Windows OS will have a file system based on SQL
Server so Access and database can still be seamless, with no "development"
required.


Nov 12 '05 #3

P: n/a
Hi Sparks,
I have a solution for you that is better than both.
I have written an application generator that allows developers to
build business applications for MS SQL Server in just a fraction of
the time it used to take. All you need to do is create the tables and
answer a few yes or no questions about each table. The generator does
the rest.

In order to demonstrate the my generator to developers, I am issuing a
promotion:

The Promotion will cost you nothing. All you have to do is send me the
TSQL scripts necessary to create your tables and to define the indexes
and foreign key relationships or I can create them for you. My
generator will do the job, and I will deliver the finished and fully
functional UI.exe along with a finished and fully functional SQL
Server back end which contains a robust security system and a
comprehensive data dictionary, completely free of charge.

The benefits of this system are as follows:
1. The system generates true Client Server and Multi Tier
applications.
2. There is Zero Coding for common functionality such as;
Adds, Updates, and Deletes,
Creating application wide unique Ids for each record,
Maintaining an Audit trail for each table,
Posting to the general ledger,
Rolling down changes to dependent tables,
Cascading deletes,
Transactions and rollbacks,
Calling validation and business rule stored procedures,
Calling post processing stored procedures,
Importing and revalidating data,
Security,
Spell checking, language translation and more.
3. There is zero work of any kind for generation of data entry
screens and their lookups.
4. The back end is completely independent from the front end. You can
hit the database with any application or user interface and still be
sure that you have complete security and valid data.
5. Easy navigation through out the application. The generated user
interface is a familiar modern metaphor with a navigation tree on top
or at the side and data entry screens at the bottom. Also, the
generated user interface remembers customizations to each data entry
screen. This allows you to make sweeping changes to the interface, and
regenerate all data entry screens, without loosing your
customizations.
6. Consistent look and feel via OOP Inheritance and code generators.
7. Major changes in look and functionality are made in one place
only, and ripple down to all affected parts of the system without
programmer intervention. Again, this was accomplished with OOP
inheritance and also with code generators.
8. Users to have the ability to create queries and reports on the
fly. And the ability to save and reload those queries and reports in
many formats including Excel and HTML.
9. Users to have complete flexibility in customizing the look and
feel of the system. The extent to which each user can customize the
interface must be seen to be believed. This high level of
customizability creates a high degree of user acceptance.
10. Logical use of hot keys and local popup menus allow for easy mouse
free operation, permitting the user to keep his or her hands on the
keyboard, if the user so desires.
11. All custom code added to generated data entry screens and
generated backend code persists after regeneration.
12. Comes with a business rule generator
13. Comes with a data import utility
14. Comes with a data revalidation utility to use when you change your
business rules.
Get all this without programming.
If you need to quickly build feature rich, bug free business
applications for MS SQL Server, then please call (201 665 8906) or
write to jo**********@aol.com
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.