VBasic 3.0 & Access

VBasic 3.0 & Access

Post by Clive Carpent » Sat, 21 May 1994 00:09:00

We have a vertical market application written in Clipper, which we need to
rewrite for Windows.

Although the application is complex, the file sizes do not reach the levels
that would require an 'industrial strength' database, like PROGRESS, Sybase,
etc. In addition, the market for this application do not really understand
the concept of paying run-time licence fees for the program.  For a number
of different reasons, we do not want to use FoxPro for Windows. It is time
for us to get away from the xBase language.

At first look, Visual Basic with the Access Engine seems to be a logical
choice for this.  It is very easy to develop a very professional user
interface with the GUI tools and there is a very wide range of third party
custom controls to further enhance it, if necessary.

The Access Engine appears reasonably robust, though perhaps not as fast as
we are used to (version 2 with Rushmore should inprove this).  Although we
are just playing at present with the SQL side of VB, we have been impressed
so far with the speed of some of the queries we have tested.  For example,
pulling 60 or so records spread right across a 12000 record table was
virtually immediate.  It also has commits and rollback - something we
consider essential for a database. It also appears that drivers are available
from companies like Phoenix that allow you access a wide range of database

However, before we leap of the pier and commit ourselves to several months
of programming effort, we would be most interested to hear from any of you
who have done a similar type of application using this product.

Specifically, answers to following questions would be most helpful -

1.  Are there any problems you know of with the robustness of the Access
Engine?  This is the most critical point for us.
2.  Is what we are considering a practical option?  And if not, why not.
3.  Although the application will have a considerable number of tables
spread across several databases, none of these tables will be very
large (maximum of 10000 records in the main table).  Can Access handle
this easily?
4.  Should we be considering any other options (other than FoxPro), that
would not require a run-time licence fee?

Any help would be greatly appreciated.  Tks in advance.

. Clive Carpenter - CC Software - Joannesburg .
. SLMR 2.1a . My other computer is a CRAY laptop.

Digitec Online - 20 Nodes  * Johannesburg, South Africa +27-11-476-2008 *


1. VBasic & Jet 3.0 Security Question

Help! I am an Access programmer moving over to VB4PE. All is going
well, except I cannot get a handle on accessing a secured database
with VB4. Each time I attempt to read the SYSTEM.MDW for logging on, I
get a "missing system database error." I reference the path and name
of the mdw file in my application.ini file. I have tested the app and
it does read the ini file on initialization. The only way I can
successfully log on is to log on as Admin with an empty password. Any
help is greatly appreciated!


2. help with simple DBGrid question

3. Where do i get Vbasic 3.0

4. default degree of parallelism for a table in ORACLE 7.3

5. Search VB.EX_ or VB.EXE of VBasic 3.0

6. ADO Recordset

7. VBasic & SQL

8. On Delete Event still holds onto deleted record

9. Problems with Q&E Driver with VBasic and Informix

10. VB 3.0 & Gobal Access Data Objects