Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006
    Posts
    1

    Red face Unanswered: Changing the Linked Table Name

    Hi All,

    I am using the code below to change the name of the linked tables. It is giving me an error "User Defined type not defined"

    Dim Jads As DAO.TableDef
    For Each Jads In CurrentDb.TableDefs
    If Left(Jads.Name, 4) = "dbo_" Then Jads.Name = Mid(Jads.Name, 5)
    Next Jads

    Please help.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    this is not a mysql question

    moving thread to, oh, let me guess, the asp forum
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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