Should I decompile?

[alex]

I’ve been trying to speed up the opening of my front-end mde by
searching this group and various other places (including Tony’s Access
Tips—which is quite helpful).

One suggestion was to decompile the source code.

Let me explain what’s going on:

I have a split Access ’03 application. The mde is about 800kb and the
mdb is about 10mb. Each user opens his/her own mde file.

When the *first* user opens the database, the switchboard loads almost
instantly (2 seconds). When the second or *subsequent* user opens the
database (when the ldb file is visible) the switchboard will load in
about 5 seconds.

In this application, the users do write to the mdb, but will never
work on the same record (each user only has access to (and creates)
individual records).

Knowing this, should I decompile? My mde doesn’t seem big enough to
warrant doing so.

Thanks,
alex

 

[Lynn Trapp]

Alex,
My first thought is that your users are a bit "spoiled," because I can't
imagine anyone being seriously concerned with a form taking 3 more seconds to
open, but that's just me.

Now, to the real issue. Does the Switchboard Items table reside in the back
end or the front end? If it is in the back end, you might consider moving a
copy of it to the mde file.

 

[alex]

Alex,
My first thought is that your users are a bit "spoiled," because I can't
imagine anyone being seriously concerned with a form taking 3 more seconds to
open, but that's just me.

Now, to the real issue. Does the Switchboard Items table reside in the back
end or the front end? If it is in the back end, you might consider movinga
copy of it to the mde file.

--
Lynn Trapp












- Show quoted text -

Lynn, that's a good point.
When the switchboard opens, it does some UserID verification from a
table(s) in the back-end.

Are you suggesting keeping a copy of the table in the mde or copying
the table when the form loads?

 

[Lynn Trapp]

It all depends on how often you need to update the switchboard. If it stays
pretty static, then justput a copy of the table in the mde and let it go. If
you have to change the switchboard up any, do it on your development copy and
redistribute a new mde.