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

    Error log on closing database

    Error log on closing the database

    I have a rather comlicated 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
    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
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Burwash, East Sussex, United Kingdom
    Thanked 229 Times in 210 Posts

    Re: Error log on closing database

    Following on from your cross-post in VB/VBA, as this sounds like it might take a long time to track down without seeing the database, if you'd care to zip the database and email it to me at I'll have a look at it when I get a chance. I'll post any findings here afterwards in case they benefit anyone else.

    Microsoft MVP - Excel

Posting Permissions

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