Open database file very slowly

[Ray]

I am using Access of Office 2003 and suddenly open the database file very
slowly. The first time I thought the program was hanged and re-booted the
system. The second time took several minutes to open instead of a few
seconds in the past. While opening, there was a warning message saying
something like that "The item is disabled and I need to enable the item from
about menu." Can someone advise possible causes and fixes.

Thanks,

Ray

 

[Guest]

Hi, Ray.

Can someone advise possible causes and fixes.

Press the <SHIFT> key and keep holding it down while opening the database
file, until the database is completely open. Select the Help menu -> About
Microsoft Office Access to open the "About Microsoft Office Access" dialog
window. Select the "Disabled Items..." button in the lower right corner of
the window to open the "Disabled Items" dialog window.

You will see a list of the items that have been disabled because they
prevented Access from functioning properly. Before you enable each item on
the list, determine what the problem is (it must be very serious if Access
disabled it automatically), fix it, then re-enable the item. You will
probably have to close, then reopen Access, for the re-enabling to take
effect.

Without knowing what the exact cause is (your listed items may help here),
we can't advise a fix. The type of problems that Access disables on startup
are the ones that cause fatal errors, i.e., crashes.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. (Only "Answers" have green
check-marks.) Remember that the best answers are often given to those who
have a history of rewarding the contributors who have taken the time to
answer questions correctly.

 

[Ray]

Gunny,

Thanks for your information. I did encounter the issue you mentioned and I
have enabled my database already. However, it still opens very slowly.
Last opening was normal. The database is design master and I have sync with
replica without issue. The replica opens normally on other machine but the
design master on that pc has problem. I tried to open the design master on
other pc via LAN and found the opening speed is normal. It seems the
database itself is no problem. What is possible issue with Access program?
How to track it down? Your further advice is appreciated.

Ray

 

[Guest]

Hi, Ray.

Since you're using Access replication, have you "illegally" moved or copied
the design master or any of the replicas? This will cause unforeseen
problems. Please see the following Web page for more information:

http://www.trigeminal.com/usenet/usenet009.asp

For further information on problems with Access replication, please see the
following Web page:

http://www.trigeminal.com/usenet

For information on performance issues that may be to blame, please see the
following Web page:

http://www.granite.ab.ca/access/performancefaq.htm

Database corruption is something to keep in mind, but since the design
master can be opened normally from other computers on the network, this
probably isn't affecting your database.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. (Only "Answers" have green
check-marks.) Remember that the best answers are often given to those who
have a history of rewarding the contributors who have taken the time to
answer questions correctly.