> I don't know how to program in Delphi or C++. I would not be
> able to create
> a DLL from the available component sets. That is certainly a
> solution that
> allows me to maintain the front-end at 90%+ VB. The time-frame is what is
> so critical here. I am managing an older system that very
> quickly needs to
> migrate to Interbase. It was Access based. I need to have this in a
> front-end that can be used on multiple systems at the same time and be
> multi-threaded. While an administrator is importing 1.2 million records
> he/she needs to be able to pull up other reports, manage other
> information,
> look-up tables, prefs, etc. Well over half the front-end is
> already built.
> I have enough experience with stored procedures, and help with it
> as well to
> manage the data in Interbase. My only major hurdle is getting
> the data into
> Interbase. From there I can deal with it. I have been managing
> and working
> on this system for 6 months. As long as I can continue to deliver working
> results I stay alive. To say that Access is being pushed well past its
> limits is a HUGE understatement right now. My database is
> growing by about
> 3 million records a month. VERY soon it will break Access since
> it just will
> not be able to handle that many updates at one time. I did not choose
> Interbase. Its a requirement since other systems are already on it and
> being coded in it. I am already a huge fan of Interbase (except for the
> fact it does not record the amount of records in a table!), but I am VB
> programmer :( So with this time-frame in effect, I don't have
> the amount of
> time neccessary to start working in Delphi and C++ and build my classes,
> objects, dll's etc. I think it would take me months to gain the
> neccessary
> skills to write in Delphi and C++ what I can write in VB.
>
>
> The only thing I dont understand is that VB is a popular language.
> Interbase HAS to be popular out there especialy since it is fairly
> powerfull, flexible and FREE. The two have to meet somewhere, but
> everywhere I go its Delphi, C++, everything-but-vb, etc.
>
>
> Edwin Epstein

Do your endusers need to pump this data regularly or do your admin staff
need to do it?
If it's the latter then I would recommend using the clevercomponents
datapump software to pump data from any ADO source to Firebird.
Not use if you need mountains of data each day/month or if its just a
"one-off" data movement you really are after.
Alan