Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

MS Access verses FoxPro

May 30, 2005 1:11AM PDT

Can someone give me some general info on which database app is better- MS Access or FoxPro. I have worked with Access but not with FoxPro.

ANY info would be great!

Discussion is locked

- Collapse -
It's the money.
May 30, 2005 1:31AM PDT

Most MS Access applications I've found incur a full charge for a copy of MS Access for each client. This can get expensive.

Foxpro Runtime can win the money issue. See http://www.google.com/search?hl=en&q=foxpro+runtime

In closing, I no longer use either and have moved to MySQL, MyODBC with custom VB apps or by accessing the data through the MyODBC. I'm also just about ready to write about Open Office's integration with MySQL via MyODBC.

It's the money.

Bob

- Collapse -
FoxPro capablities?
May 30, 2005 4:54AM PDT

Thanks Bob! As far as capablities???

Does FoxPro use SQL and VB (VBA?) for queries as well as programming?

- Collapse -
Last time I looked, yes.
May 30, 2005 5:05AM PDT

But I dropped a not so subtle hint that I have moved on. You can, today move past these and head straight to the first class database section.

Bob

- Collapse -
Trial Version?
May 30, 2005 11:34PM PDT

Thanks for all the info! One last question- Is there a trial version I can download for free or at low cost before actually buying the software? I looked on Microsoft but couldn't find anything.

Thanks again!

- Collapse -
MySQL is GPL.
May 30, 2005 11:41PM PDT

You can use it freely. MyODBC is also a similar license which you can obtain freely.

Then you install Open Office, set your ODBC source and you have your first class SQL solutions. Price? Download time.

Microsoft products will cost a bit more.

- Collapse -
FoxPro?
May 30, 2005 11:44PM PDT

Are we talking about FoxPro?

- Collapse -
You didn't ask about Foxpro, but about...
May 30, 2005 11:50PM PDT

Database solutions.

If cost is an issue, we can fix that.

-> About FoxPro. It is a computer language underneath it and if you are not a programmer willing to pick up the FoxPro language then you should not entertain that.

Bob