saving module

  • Thread starter Thread starter iccsi
  • Start date Start date
I

iccsi

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,
 
It seems that MS Access run all queries in the database when developer
saves VBA file.
Click to expand...

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)
 
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 Leachwww.tristatemachine.com

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










- Show quoted text -
Click to expand...

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,
 
On Jan 5, 5:43 pm, Jack Leach <dymondjack at hot mail dot com> wrote:

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,

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.
 
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

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)
 
On Jan 5, 5:43 pm, Jack Leach <dymondjack at hot mail dot com> wrote:

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,

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.
Click to expand...

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