1. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

Opening and Closing a Form in Access 2000 Hundreds of Times changes the fonts

Discussion in 'Other PC Software' started by SITO, 2002/07/05.

Thread Status:
Not open for further replies.
  1. 2002/07/05
    SITO

    SITO Guest Thread Starter

    Excuse me but my english isn't very good.

    The problem is in Access 2000 with Service pack 2.
    The problem occur in Window NT and Windows 2000.

    When I open and close a form hundreds of times, the fonts of the forms, the color of the buttons, the access labels (forms, reports, queries, ...), the properties window, ... change.

    For example, access change the font and color to a button, but another not, the data that are obtained of the database have different fonts,...

    It seems as if the access had become crazy, or not it had enough memory to be able to show everything correctly.

    Also, if I move a form on another, access change the fonts and background colors of the buttons, labels and text box of the opened forms.

    It is a very strange thing that I had never seen.

    Please I need help quickly.

    Thank you in advance.

    Regards.
     
    SITO,
    #1
  2. 2002/07/06
    pweegar

    pweegar Well-Known Member

    Joined:
    2002/07/06
    Messages:
    40
    Likes Received:
    1
    Now that IS strange. Opening and closing databases, forms and reports in Access shouldn't change ANYTHING. How large are your databases? I would suspect fragmentation may be causing some problems. I've see very large Access db's cause lots of fragmentation, to the point where the db would stop responding (we are talking hundreds of thousands of records. Something I don't like to do often). Defrag your HD and see what happens.
    IF you are in a business and this is an ongoing problem, I would say it's time to convert to a more powerful DBMS such as MS SQL Server. Something that can handle opening and closing like you do.
     

  3. to hide this advert.

  4. 2002/07/09
    Hex92

    Hex92 Inactive

    Joined:
    2002/01/08
    Messages:
    153
    Likes Received:
    0
    Try this:
    Back up your DB.
    Open it.
    Go to tools>database utilities>compact and repair database.

    that might fix your problem.
     
Thread Status:
Not open for further replies.

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.