Slow open in design?

[MAT]

Hello,
I using Access2K Develop Version and Win2K.
I have a .mdb file, so what happen couple day ago whenever
I click on the form and click Design it took me 1-2
minutes to open the form.
Anyone have any ideal, please advice.
Thanks you,
MAT

 

[Fred Boer]

Dear MAT:

Is the Name Autocorrect option checked? Try turning it off and see if that
makes a difference.

HTH
Fred Boer

 

[MAT]

Dear Fred,
The Nam Autocorrect option not check. So , even I open
report design it took me over 1 minute to open! I wonder
is it my Access corrupt?
Regards,
MAT

 

[Fred Boer]

Dear MAT:

Well, I have one more suggestion: have you split your database into a front
end/back end arrangement? If so, and if the delay happens if someone else is
accessing the back end at the same time as you are doing the design work,
you might be having an LBD locking problem.

If this is your situation, try disconnecting the front end from the back end
and then try doing the design work.

There is more information about LBD locking here:
http://www.granite.ab.ca/access/performanceldblocking.htm

HTH
Fred Boer

 

[MAT]

Hi Fred,
Thank you for reply.
I am not yet split to FE/BE. It still in development just
only me access to database, therefore, I do not know what
cause the problem? I plan to reinstall MS-Office package
(?) will it work?
Regards,
MAT

 

[Fred Boer]

Sorry, MAT... I've reached the end of my short list of ideas...

Hopefully, a real expert might jump in! Anyone??

Good luck!
Fred Boer

 

[Fred Boer]

BTW, MAT, if you don't get another reply after a reasonable time, you might
want to repost in "microsoft.public.access.reports"... Seeing that I have
responded *might* make other people think your problem is being dealt with,
and they might not bother to follow the thread to the end .....

Fred

 

[Dirk Goldgar]

Hello,
I using Access2K Develop Version and Win2K.
I have a .mdb file, so what happen couple day ago whenever
I click on the form and click Design it took me 1-2
minutes to open the form.
Anyone have any ideal, please advice.
Thanks you,
MAT

Fred already asked about the Name Autocorrect option -- that's the first
thing I'd check. Is the form's recordsource a table, or a query
(whether a stored query or an SQL statement)? If it's a query, does the
query itself take a long time to open and return records?

Does the form take a long time to open in form view, or only in design
view?

 

[MAT]

Thank you all for reply,

It happen when I click Form Design view only, also it does
not have any recordsources or queries.
Quit Access, restart window, open .mdb file, click any
forms to view in design view ==> COmputer like to be
hangup a couple minute then it open a form for you?
Is it weird?
Best regards,
MAT

 

[Dirk Goldgar]

Thank you all for reply,

It happen when I click Form Design view only, also it does
not have any recordsources or queries.
Quit Access, restart window, open .mdb file, click any
forms to view in design view ==> COmputer like to be
hangup a couple minute then it open a form for you?
Is it weird?
Best regards,
MAT

Yes, it is weird. Is the database file on your local hard disk, for
example on your C: drive, or is it on a network share?

 

[Reggie]

Mat, do you have a lot of forms in your app? If so do they all have modules
associated with them. If so, open the VBA editor and close down all the
open modules. Click Debug/Compile from the main menu(if not available just
close the editor). Close the editor. From here Select Tools/Database
Utilities/Compact and Repair from the main menu. It's a long shot, but may
help!

 

[MAT]

Hi Reggie,
I follow your instruction but it not working!
I reinstall Office and update it, now it working as normal.
Thanks a lot for your advices,
Regards,
MAT

 

[MAT]

Hi ,
I reinstall Office and update it, now it working as normal.
Thanks a lot for your advices,
Regards,
MAT

 

[MAT]

Hi,
I reinstall Office and update it, now it working as normal.
Thanks a lot for your advices,
Regards,
MAT