Results 1 to 2 of 2

Thread: Need help with ADODB Connection....

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Jan 2002
    Location
    http://www.vbforums.com
    Posts
    164

    Angry Need help with ADODB Connection....

    Hi guys, I'm facing with a terrible problem here.
    I wanted to backup a my system database in run time.

    In my backup form, I've set
    connection.close
    set connection = nothing

    but to no avail, my "filecopy" still couldn't access the .mdb file....becuase it was locked....

    Please can anyone help me? I've tried unloading all forms but still the lock remains....my understanding is...if the .mdb file is locked it means the connection is still there rite?
    "If ignorance is bliss, that probably explain why I'm in a such a mess right now!!"

  2. #2
    Frenzied Member
    Join Date
    Feb 2001
    Posts
    1,140
    Copies of the connection object? Open recordsets? Other users? Zombie threads?
    Travis, Kung Foo Journeyman
    As always, RTFM.

    WWW Standards: HTML 4.01, CSS Level 2, ECMA 262 Bindings to DOM Level 1, JavaScript 1.3 Guide and Reference
    Perl: Learn Perl, Llama, Camel, Cookbook, Perl Monks, Perl Mongers, O'Reilly's Perl.com, ActiveState, CPAN, TPJ, and use Perl;
    YBMS, but Mozilla doesn't.

Posting Permissions

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



Click Here to Expand Forum to Full Width