General discussion

Locked

Advice Please - Convert Dbase to what?

By Data Knight ·
Hi All

What is the best AND/OR easiest-to-convert-to/learn development environment to take old Dbase programs, forms and databases into the visual age.

I have done a little VB / VBA and certainly no data access with it. I have toyed with the idea of MySQL and HTML/Web front-ends but I need to do conditional data validation as well.

The database would be single user but needs the ability to be exported and merged with an identical one on another machine.

The resulting application would ideally fit onto a floppy disk as the data volumes are not high. Maybe 100 records max.

The critical thing is the data validation based on a three fields hierarchy. More details could be supplied offline.....

Someone may say why not use something like Excel to do the input but it comes down to the specifics of the data validation based on a separate data table.

Thanks for the feedback

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Advice Please - Convert Dbase to what?

by Ann777 In reply to Advice Please - Convert D ...

Almost everyone uses MS Office... so why not design this in MS Access?

Access Runtime is just as available as the VB Runtimes and it's geared toward DB querying and manipulation. Yes, it has some limits... but if you don't want to spend a whole lot of $'s, then it may be an alternative for you.

Collapse -

Advice Please - Convert Dbase to what?

by Data Knight In reply to Advice Please - Convert D ...

I need to elaborate further. The databases are for a charity for an annual sports day data entry app.(so it's outside of work). The endusers are likely to be home users and not have Access natively. They're allowed 3 events. If an event is restricted then only 1 restricted event is allowed. If they're under 18 the max # events they can enter is 2 track or 2 field events plus 1 of the opposite type. I would need drop down lists of valid events to select from etc......

Collapse -

Advice Please - Convert Dbase to what?

by opatzg In reply to Advice Please - Convert D ...

Anna's suggestion still works, you'ld need to write a VB app to handle your hierarchy limits on field entry. Is the not accepting due to the cost of access? Then set up the events across the top of a spreadsheet with those that are exclusive and those tha allow multiples and sort names or id numbers for entrants to make sure they are not double entering, and you can just eyeball it. If your only talking 100 registrants that should be acceptable to just look up and down a sorted screen. Keep your columns narrow and you should be able to fit a lot on the screen at one time, format the wrap function of the field in the column to have a good description of the event at the top.

Collapse -

Advice Please - Convert Dbase to what?

by Data Knight In reply to Advice Please - Convert D ...

Sorry guys; this question is really too complex for this Q&A scenario; it would have been better to have gone to a newsgroup/forum and asked my question there. As far as the Excel option is concerned there would be too many options across the top ofthe screen - something like 200 events. No-one is going to scan that sort of data visually. The data has to be verified as OK before it gets back to me.

Collapse -

Advice Please - Convert Dbase to what?

by Lord Ago 1 In reply to Advice Please - Convert D ...

Delphi would actually be a good choice for you. The main reason I suggest this is because you made mention of size(fit on a floppy). Delphi can do this because it doesn't need the runtime files like Visual Basic. The previous answers had it right with using Access databases. Delphi 5 can also use Access databases with an ADO control. There's a pretty good tutorial on www.about.com concerning developing with Delphi and database programming with Delphi. Using Delphi is very similar to using Visual Basic. Also note, most windows based programming languages can already make use of the dBase file. Of course, that takes some more learning/getting used to.

Have Fun!!!

Collapse -

Advice Please - Convert Dbase to what?

by Data Knight In reply to Advice Please - Convert D ...

I like the Delphi option; there's some good stuff in it but to to do database access requires the Pro version which here in the UK is very expensive and I cant justify it. Maybe someone could give me a copy for free! ;-) (It seems that you have to buy the PRO version of anything to do database access which is always expensive)

Collapse -

Advice Please - Convert Dbase to what?

by Data Knight In reply to Advice Please - Convert D ...

This question was closed by the author

Back to Web Development Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums