[AccessD] Large MDE file

John Skolits JSkolits at CorporateDataDesign.com
Mon Feb 10 08:11:04 CST 2003


Well, after doing this for too many years to say in this newsgroup, I would
'Highly' recommend to start from scratch. VB or Access, it's up to you. If
you can find a good Access developer to do it for you, it will take a lot
less time than you might think. If you use VB, it'll take longer to develop
but will be a bit more flexible. I'm an Access guy and if it's a database
that will be used internally (within the company), Access is the way to go.
But, I won't bad mouth VB. You just have to find the right person.

Good luck.

John


-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com]On Behalf Of
marcel.vreuls at achmea.nl
Sent: Monday, February 10, 2003 8:30 AM
To: accessd at databaseadvisors.com
Subject: Betreft: RE: [AccessD] Large MDE file



Hi John,

The MDB is available too. I have adopted the application for 2 years ago
and it is certainly not perfectly written. The earlier programmer was a
starter. I have 6 six years of experience but mainly on Clipper en C++ and
a little bit of VB. So I had to learn something too :-).

No you did not insult me, do not worry. Nobody is perfect :-) and I have
made mistakes too. That is why the idea of starting al over again keeps
coming up :-).  I have now a lot more experience.

What I have to do is:
- Convert all DAO to ADO
- Make generic forms.
- Replace all the code behind forms in generic modules and functions to
make it re-usable.
- and so on.

But thanks anyway. If you have any tips on how to go ahead with this
project. Please let me know. I have found some tools to create datalayers
which contain the major functions like update-insert-delete for alle
dataobjects. From there on I can redesign forms and code.

Gr. Marcel








John Skolits <JSkolits at CorporateDataDesign.com>@databaseadvisors.com op
10-02-2003 14:04:49

Antwoord aub aan accessd at databaseadvisors.com

Verzonden door:     accessd-admin at databaseadvisors.com


Aan:  accessd at databaseadvisors.com
cc:

Onderwerp:     RE: [AccessD] Large MDE file


Maybe a dumb question but where is the MDB version of your application? I
would say 20 Meg is a sizable application. Assuming it has no data and only
code, something like that would take a long time to develop if written
well.
In addition, I wonder how well written it is. I've written some pretty
large
application, but a 20 meg one is pretty big. The only possible place where
I
see it getting that big with no data is if you have a lot of reports or
many
forms with bitmap images.

    "The MDE is becoming to large and ""slow"" to handle everything"

I believe, there are too many factors in an application to make that
general
comment. With 20 megs, a lot could be poorly written.

    "Also more often errors keep coming up "

In a perfect world, there should be no errors, but there is an implication
in your statement that makes me think, you've been having many problems to
begin with. All this points to a poorly written application, (Sorry if I've
insulted you, assuming you wrote the code)

I think the issues will only be worse if you convert it to VB. It's a 20
Meg
Access database application and I can't imagine the  amount of work it will
be to convert. Then again it may have all unbound forms. That would make it
easier to convert but also a sure sign that the person who wrote it should
have written it in VB in the first place and never tried to do it in
Access.
(Please-no attacks on that last comment, I'm a bounder!)

You need to get the MDB version and see how it was written before
considering a conversion.

That's my opinion. /Enjoy the thread/

John Skolits (ducking for cover)









-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com]On Behalf Of
marcel.vreuls at achmea.nl
Sent: Monday, February 10, 2003 5:03 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Large MDE file



Hi Group,

I am strugling with the following. My application is a application for
administring orders en commission revenues for agents in the furniture and
paper branche. The MDE is now about 20 MB large. This is only code. The
tables are in a seperate MDB file. This is after the following steps

1. Import the database into a new one.
2. Set the references
3. Repair-Compact the database
4. Saving it into MDE state.

The MDE is becoming to large and slow to handle everything. Also more often
errors keep coming up which are over after restarting and compacting the
MDE database. I am looking to convert the MDE to Visual Basic and have
tested some tools as VB Express en Com Express.

Is there anyone who has tips/experience in with this.
1. porting Access 2000 apps to VB and what the extra work will be (DAO to
ADO)?
2. the use of VB Express or Com Express or different programs?
3. Are there companies who have experience or could do the major part of
the conversion for me?
4. After analysing and overthinking the proces. The idea of starting all
new again is still sounding better. But the hours....pfff...



Your opinion?

Thanks, marcel






********************* DISCLAIMER *********************
De informatie in dit e-mail bericht is uitsluitend
bestemd voor de geadresseerde. Verstrekking aan
en gebruik door anderen is niet toegestaan.
Door de electronische verzending van het bericht
kunnen er geen rechten worden ontleend aan de
informatie.
************************************************************

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


*****************************************************************
Dit bericht is bij binnenkomst gecontroleerd op de
aanwezigheid van virussen. Er zijn geen (bekende)
virussen gevonden.  Active
*****************************************************************






********************* DISCLAIMER *********************
De informatie in dit e-mail bericht is uitsluitend
bestemd voor de geadresseerde. Verstrekking aan
en gebruik door anderen is niet toegestaan.
Door de electronische verzending van het bericht
kunnen er geen rechten worden ontleend aan de
informatie.
************************************************************

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list