Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Oct 2002
    Location
    Lakewood, New Jersey, USA
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    using ADO to relink tables (Access 2002)

    Can I use ADO to relink tables? What's the equivalent to DAO's tabledef.RefreshLink?

  2. #2
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: using ADO to relink tables (Access 2002)

    Recommend check MSKB article 275249:

    ACC2000: How to Use ADOX to Create and Refresh Linked Jet Tables

    Be advised, ADO is slower than DAO for this, and bloats the database more than DAO, as noted in this previous post:

    <!post=Post 228652 - Re: What causes .mdb file to grow? (Access 97),228652 >Post 228652 - Re: What causes .mdb file to grow? (Access 97)<!/post>

    HTH

  3. #3
    2 Star Lounger
    Join Date
    Oct 2002
    Location
    Lakewood, New Jersey, USA
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: using ADO to relink tables (Access 2002)

    Thanks, Mark. I'll have a look at that article and post.

Posting Permissions

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