Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    228

    Unanswered: updating linked tables via VB

    I am trying some code like this ...

    tdfLinked.Connect = ";DATABASE=" & proj_path
    tdfLinked.RefreshLink

    to update/change the location of the backend tables for my database.

    I get a runtime error 3219, invalid operation.

    My goal is to have a main menu show on startup where the user will pick a project from a list. The choice will determine what tables are linked up to the frontend. It works using the linked table manager but I want to code it.

    thanks

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926

    Update dsn's

    Maybe the attachment will help although it's more for SQL Server linked tables.
    Attached Files Attached Files
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

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