Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    3

    Arrow Unanswered: upsizing Access to SQL server

    Ok,
    No problem creating a dsn on my machine, using that dsn to export the a remote SQL server. Everything looks great, except that SQL Server renamed all of the tables.
    Ex:

    products to db1.products
    categories is now db1.categories
    users is now db1.users

    Is there anything I can do to get SQL Server to display the original table names?



    Very Much Thanks

    Dave

  2. #2
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665

    Re: upsizing Access to SQL server

    Originally posted by DaveCam
    Ok,
    No problem creating a dsn on my machine, using that dsn to export the a remote SQL server. Everything looks great, except that SQL Server renamed all of the tables.
    Ex:

    products to db1.products
    categories is now db1.categories
    users is now db1.users

    Is there anything I can do to get SQL Server to display the original table names?



    Very Much Thanks

    Dave
    the server is displaying the correct names the db1. is an extention indicationg the name of the database. you can rename linked tables and remove that part and it will work fine
    Jim

Posting Permissions

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