Desktop Front End Datase help. NO MS ACCESS, any clues who to use,

[jmiller79]

I am looking to create a desktop front end database application (NOT MS ACCESS). I also would like some info on the difference between MS SQL and Oracle Backend. I need to develop a front, what would be the best front end and what would be the backend to go with that front end. I am clueless regarding how to develop a front end. Some people have pointed me towards Visual Basic or VB.net. This database will eventually hold over a million records. It will be user to enter freight bills. There will be about 15-20 user on at the same time all day and about 4-5 user on at the same time running detail reports. Any help or directions would be great; we are currently using a backend of “progress” with an ugly frontend of “progress”. If anyone needs more info, please ask. Thanks for all your opinions and responses

 

[lespaul]

You can use just about any language to create a front end for any database. We currently use Delphi, but C++, Java, Visual Basic, etc. can all create front ends. Just depends on what you are comfortable coding in. If I got to pick I would choose Delphi, but that's because that's what I already know and there would be a learning curve (for me) for any of the other languages.

As far as the backend, you can also look into MySQL, which is a great product and is free.

Leslie

 

[terosoft]

If you feel more comfortable in a db environment you could try MS Visual Foxpro. It has one of the fastest desktop db engines, a powerful yet simple language and an interface similar to VBasic among other stuff.
Besides you can find several VFP forums at this site to ask for aid.

Gerardo Czajkowski