Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Nov 2001
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    rename a table in remote database (Access 2000)

    Rename a table in remote database

    How can i rename a table in a remote database?I know how to delete the table but not how to rename it.
    Using the Command DoCmd.rename "OldTable", acTable, "NewTable"
    refers to the current database i am working in and not to the remote database.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: rename a table in remote database (Access 2000)

    First explain what you're trying to accomplish. Are you just playing with this to see how it works or do you need to do this for a purpose? Renaming a table in another database, like deleting a table, can have significant repercussions on the operation of that remote database. It isn't something to be done casually, and I don't see much purpose in doing it with intent.
    Charlotte

Posting Permissions

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