Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

saving module

0 views
Skip to first unread message

iccsi

unread,
Jan 5, 2010, 1:38:25 PM1/5/10
to
It seems that MS Access run all queries in the database when developer
saves VBA file. Please let me know if I am wrong.

It takes more than 5 minutes to save my module even only one line of
code changed. If I do not save the module then I will lost my code if
the code failed.

I just wonder even I use unbound controls that MS Access still running
all queries when developer save module or form design.

Are there any workaround for this issue?

Your help is great appreciated,


Jack Leach

unread,
Jan 5, 2010, 5:43:01 PM1/5/10
to
> It seems that MS Access run all queries in the database when developer
> saves VBA file.

I'm pretty sure that's not correct - not quite 100% sure, but maybe more
like 99.9999%

It shouldn't be taking this long to save. Have you tried a Compact &
Repair? Be sure to back up first...

hth
--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)

"iccsi" wrote:

> .
>

iccsi

unread,
Jan 5, 2010, 6:12:48 PM1/5/10
to
On Jan 5, 5:43 pm, Jack Leach <dymondjack at hot mail dot com> wrote:
> > It seems that MS Access run all queries in the database when developer
> > saves VBA file.
>
> > .- Hide quoted text -
>
> - Show quoted text -

Thanks for helping,

I have auto compact while closing the database.
I see networking activity in task manager while I open a form or save
a form.
It takes a long time to open a form at design mode as well.
If I am wrong, any suggestions to look the issue?

Thanks again for helping,

Mike Painter

unread,
Jan 5, 2010, 7:39:39 PM1/5/10
to

"iccsi" <inu...@gmail.com> wrote in message
news:c168ba75-69f6-47fe...@c34g2000yqn.googlegroups.com...

Thanks for helping,

Thanks again for helping,

Is the database you are working with on a network?
Opening a form in design mode should not take much time under any
circumstance.

Check the cables, it's always the cables.


Jack Leach

unread,
Jan 6, 2010, 6:14:01 AM1/6/10
to
It probably doesn't have much to do with your issue, but compact on close is
not really supposed to be used. I don't know the reasons well enough to
explain it myself but there's numerous posts on the boards here where some
mvps and others more knowledgable than I give reason why it should never be
used.


--
Jack Leach
www.tristatemachine.com

"iccsi" wrote:

> .
>

iccsi

unread,
Jan 6, 2010, 7:50:30 AM1/6/10
to

Yes, my application has network. It seems to run the queries while I
open the form in design mode

0 new messages