Results 1 to 3 of 3

Thread: Closing an .mdb file after the DataReport

  1. Jul 31st, 2000, 11:33 AM #1
    MattS
    MattS is offline

    Thread Starter
    Junior Member
    Join Date
    Jul 2000
    Posts
    30
    Hey all,

    I'm trying to compact a database in VB6. It won't let me do that until the .mdb file is closed. I can get the database closed with code in most cases, but not after I view a report generated by the Data Report tool. When the report is generated, the database will not close until the application is terminated. How in the world can I do this?

    The name of my command in the Data Environment is Catalog, so I've tried:

    Catalog.Connections.Item(1).Close

    and all variations of that I can think of...

    Please help!!!
    Matt
    Reply With Quote Reply With Quote
  2. Jul 31st, 2000, 01:34 PM #2
    Dr_Evil
    Dr_Evil is offline
    Lively Member Dr_Evil's Avatar
    Join Date
    Mar 2000
    Location
    Columbus, OH
    Posts
    105
    I'm not sure if this would help but have you tried setting your DataEnvironment = Nothing?

    Code:
    Set DataEnvironment1 = Nothing
    just a thought...
    Dr_Evil
    Senior Programmer
    VS6 EE
    VS.NET EA
    Reply With Quote Reply With Quote
  3. Jul 31st, 2000, 01:38 PM #3
    MattS
    MattS is offline

    Thread Starter
    Junior Member
    Join Date
    Jul 2000
    Posts
    30
    Thanks for the reply. I already tried that, but nothing. Anybody with more ideas?
    Matt
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width