Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Posts
    84

    Unanswered: Linked tables properties - Where? How?

    Have few MS Access frontends - mdb's, which has many SQL Server tables as linked tables, and MS Access tables inside. I have to migrate them (SQL Server tables) from one SQL server to another and to change linked tables properties in MS Access, related to MS SQL Server's tables.

    Anybody has idea how to do it?

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    The easy way is to move your sql server tables, click "Linked Table Manager", select all (or just the moved tables) and tick the "prompt for new location" box. Press ok and you will be asked to relink the tables.

    HTH
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Mar 2004
    Posts
    84
    Thanks!

    You mean:
    Tools > Database Utilities > Linked Table Manager

    This would be the perfect solution.
    Just have to have administrator privileges (if the menu option Linked Table Manager is not active), cause the database is read only for all other but admin group, and few users.

    Thank you very much!

  4. #4
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601
    That is what he meant...
    You will have to have full privileges.
    Ryan
    My Blog

  5. #5
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,418
    Provided Answers: 7
    as the data is not on you computer

    you have to let that computer that is storing the data know how the use can us the file read/write talk to you IT person

    tell then Your would like all user to have read/write and delete on that folder


    Get them to share it with the $ at the end of the name
    This will make i hidden What people can't see they can't delete.
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

Posting Permissions

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