Results 1 to 3 of 3

Thread: Compact & Repair Access Database.

  1. Dec 8th, 2001, 01:55 PM #1
    Mahbub
    Mahbub is offline

    Thread Starter
    Lively Member
    Join Date
    Feb 2001
    Location
    Bangladesh
    Posts
    74

    Lightbulb Compact & Repair Access Database.

    How can I compact & Repair Access Database from visual basic?

    DAO can do this. But I want to do it with ADO or Access Automation by VB. My database is password protected (database Password)

    Can you help me?
    'Nothing lasts forever, even cold November Rain'
    Reply With Quote Reply With Quote
  2. Dec 8th, 2001, 02:27 PM #2
    gab2001uk
    gab2001uk is offline
    Hyperactive Member
    Join Date
    Sep 2001
    Location
    St. Albans, Herts, UK
    Posts
    259
    http://www.planet-source-code.com/xq...s/ShowCode.htm
    Graham, www.gab2001uk.com VBExplorer Forum Moderator VBExplorer
    www.gab2001uk.com For comparing and contrasting DAO with ADO
    Code for Creating, Copying, Compacting, Replicating, Synchronising Access 97/2000 databases plus showing Schemas and using .Seek
    Reply With Quote Reply With Quote
  3. Dec 9th, 2001, 03:15 PM #3
    Mahbub
    Mahbub is offline

    Thread Starter
    Lively Member
    Join Date
    Feb 2001
    Location
    Bangladesh
    Posts
    74

    Thumbs up

    Thanks A lot. It helped me. I also tried with access automation. (Reference to access 9.0 object library). It has a method to compact database. but I failed to use it with database password.

    Thank you again.
    'Nothing lasts forever, even cold November Rain'
    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