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

    Unanswered: updating linked tables via VB

    I am trying some code like this ...

    tdfLinked.Connect = ";DATABASE=" & proj_path

    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.


  2. #2
    Join Date
    Dec 2004
    Madison, WI

    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