Results 1 to 4 of 4
  1. #1
    elb1999 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    4

    Moved Database - Now Query wont run

    I'm working in Access 2010. I had my database in my private folder on the network, but I'm leaving the company, so I moved it so it would be accessible by my replacement. I'm training him and when I try to run the query the I get an invalid file path message, which is correct because Access is "pointing" to the old file path. Where do I go in Access to change the file path?

  2. #2
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    Is it a split database? If so, all you need to do is re-split it from the new location and it will all be set. Alternatively, you can go to the linked table manager and reset the links to the new location.

  3. #3
    elb1999 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    4
    Thanks....the linked tables manager was the solution

  4. #4
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    Anytime. Glad you got it resolved

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Database wont open
    By sarah54 in forum Access
    Replies: 22
    Last Post: 12-08-2010, 08:38 AM
  2. Query and subquery wont work with combo box
    By jbg8931 in forum Queries
    Replies: 0
    Last Post: 05-09-2010, 10:24 AM
  3. New Record has moved all other records...
    By medmons in forum Access
    Replies: 0
    Last Post: 06-01-2007, 01:00 PM
  4. Replies: 0
    Last Post: 03-26-2007, 02:12 AM
  5. All Data wont show
    By Wrangler in forum Queries
    Replies: 1
    Last Post: 01-02-2006, 03:27 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums