Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Error log on closing database

    Error log on closing the Access database


    I have a rather comlicated MS Access database in which on opening the main form 8 other forms are also opened, since I am using a code basxed on the
    If IsOpen(strDocName) = True Then
    Event.
    The problem is that I cannot close the database.I receive the following error:
    ==============================
    MSACCESS has generated errors and will be closed by Windows.You will need t0
    Restart the program.
    ==============================
    An error log fas been created.
    I have tried to close all the form with a code, but without success.Even the simple clsoe action from the toolbar gives this error.On the other hand,if these forms are not opened, I can close the database easily.Therefore the problem lies in the opened forms.But I do need to open these forms.
    Is there any way to obviate this problem and close the database.If I could do this my problems will be solved.
    I will be extremely grateful to any advice or solution

  2. #2
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error log on closing database

    Post the code and let's have a look.
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error log on closing database

    tgahnk you for the reply.I am afraid i shoudlk,s end the whole database,however i coukd zip it and it will niot be greater than 700KB. If you woukd agree to have a look pleae let me knwo w your email address.
    Once again thank you very much
    Best regards

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Error log on closing database

    This thread really belongs in the Access forum rather in VB/VBA.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •