[AccessD] Large MDE file

John Skolits JSkolits at CorporateDataDesign.com
Mon Feb 10 07:05:00 CST 2003


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




More information about the AccessD mailing list