Decision to convert

D

debellisra

I have created a program is MS Access which allows me to create text output
that is readable by our mainframe (main purpose). This process includes
running cutome queries what are appended to formated tables and then these
tables are output to text. I would like to migrate this program out of Access
to a stand alone application that anyone could run. My question is should I
leave the database native to Access and Visual Studio to create the front
end? Or should I completely re-create my program in Visual Basic? Any ideas?
 
D

debellisra

Hi Rick

My query is whether to leave my program in MS Access or to reconstruct it in
a more stable environment like a stand alone VB application. I can construct
my tables in any database like SQL or Oracle, However, I have done alot of
work with queries, reports and macros in MS Access. Is it worth leaving in MS
Access (the process no the database tables)
 
R

Rick Brandt

debellisra said:
Hi Rick

My query is whether to leave my program in MS Access or to
reconstruct it in a more stable environment like a stand alone VB
application. I can construct my tables in any database like SQL or
Oracle, However, I have done alot of work with queries, reports and
macros in MS Access. Is it worth leaving in MS Access (the process no
the database tables)
Click to expand...

Why would you consider a VB front end "more stable"? Writing your front end
will take LOTS more time in VB especially considering that you already have
written it in Access and you would essentially be starting over from
scratch.

If the jist of your question is "What makes a better database front end,
Access or VB?" and you are asking the question in an Access Newsgroup what
sort of responses do you expect you will get?

VB is a general purpose development tool. Access is specifically geared
towards database interaction. Yes, it is easier to create something that is
more "stand-alone" with VB, but again at the cost of a lot more work to get
the same functionality.
 
K

Klatuu

The stability of an Access based application is dependent more on the skill
of the developer than the capabilities of Access. The same would be true of
VB or any other developement tool.

You are sounding like one of those mainframers who thinks Access or anything
 
D

David W. Fenton

Lots of programs use Jet files as their database and
do so without the Access program. All you need are the Jet dlls
(MDAC) to work with data in an MDB file.
Click to expand...

Er, the MDAC has not included the Jet DLLs for several years now.
 
D

David W. Fenton

My query is whether to leave my program in MS Access or to
reconstruct it in a more stable environment like a stand alone VB
application.
Click to expand...

The only reason Access has ever had a reputation for "instability"
was because when it's used with Jet data by someone who doesn't know
what they are doing, the Jet data often get corrupted.

If you're not using a Jet back end, there is *no* instability
involved with Access.

There is only requirement for having Access installed or the Access
runtime.

Michael Kaplan did work a long time ago to compare the actual
workset (i.e., the amount of memory used, the number of DLLs loaded,
etc.) when using Access or an Access runtime vs. a VB front end, and
he found that the difference was very small.

And an Access app is *much* easier to create.

Seems like a complete no-brainer to *me*.
 
R

Rick Brandt

David said:
Er, the MDAC has not included the Jet DLLs for several years now.
Click to expand...

True, but a version of MDAC that does include them is still available as a
download.
 
Top