Access 97 does not close after running code

Hot Topic

ned help with excel
custom toolbar error
read only file opening
Is an Excel bug that set PivotItem.Visible to true will generate 1004 Macro Error?
VBA64SDK Compatible with VC2005???
Word 2000 section page numbering bug? Any workaround?
Using Built-In Constants in VB.net / Word
Opening a Word file from a macro in Excel
Runtime error '13' - type mismatch problem! Again...
Publishing Scorecard in BSM

Microsoft ISV

Ms Access form creation
Novice Programmer needs help
Program code fro sorting coloumns in a listbox VB Excel
Macro to sort an Excel column
Microsoft Document Image Printer - MODI Registry Settings
How do I do to work with two XML files in VBA
Questions about using Windows Workflow Engine in ISV app.
Detect Excel Version in VB6 Application
Working with Outlook Public Folders from Excel
VBA Out Too?

Access 97 does not close after running code

I have a number of access databases that do not close after I have run code attached to buttons on forms. All the databases read text files and open recordsets to write the data into my tables. I have ensured that I close each recordset and database object, and I set them to equal to nothing at the end of the code.

I have tried using the repair option on the database, but I still get the problem. The only way I can close the Access window is from task manager.

Any suggestions



Answer this question

Access 97 does not close after running code

  • -_Cypher_-

    Many thanks.

    I was looking for the wrong problem. The problem was in my if statements which tested radio buttons, I added =True and to the relevant lines and it cured my problem.

  • Sentinel3304

    Per the support engineer:

    I understand that your Access databases cannot close after running some code. Please notice that Microsoft does not support Access 97 now. You can check the following link.
    I am just offering some suggestions here, though we cannot support Access 97.
    1. From the description, it seems the database is not responding (can only be closed via Task Manager). Usually the problem could occur when your code is still running and consumes a lot of CPU time. You can check this.
    2. I found some articles for your reference. You may check if they apply.
    ACC97: Unable to Quit Microsoft Access
    http://support.microsoft.com/kb/190074/en-us
    ACC: Problems Quitting Microsoft Access
    http://support.microsoft.com/kb/164455/en-us
    ACC97: Database Does Not Close and Reopen After Failed Synchronization
    http://support.microsoft.com/kb/164785/en-us
    3. If there is error message, you can search on http://support.microsoft.com/.

    -brenda (ISV Buddy Team)



  • Access 97 does not close after running code
Answer this question