Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Nov 2001
    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
    Sacramento, California, USA
    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.

Posting Permissions

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