Why would database in Access Runtime point to incorrect directory?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • spulliam

    #1

    Why would database in Access Runtime point to incorrect directory?

    I have created a database on my computer which has the full application of Access 2007. The users I want to have access will be using Access runtime 2007.

    I have split the database and copied both frontend and backend files to the shared drive but, the frontend file keeps pointing back to the original location the database was created in when viewed in runtime. When I go to view it on the shared drive it appears at location of the shared drive. How can I redirect the path for the file in the shared drive so I can view the information in runtime?
  • dsatino
    Contributor
    • May 2010
    • 393

    #2
    Sounds like you split the DB prior to moving it to the shared drive. You'll have to redirect the front end(s) to the shared drive.

    Open the front end
    Right click on any linked table
    Select the 'Linked table manager' option (or something of that sort)
    Remap to the shared drive

    Comment

    • spulliam

      #3
      I did split the database before placing it on the shared drive. I attempted to link the tables and remap as you suggested but, I am still getting the same message. Would I be able to bring the database back together then re-split on the share drive? Help... I am no expert by any means but, I am trying my best to make this work.

      Comment

      • MMcCarthy
        Recognized Expert MVP
        • Aug 2006
        • 14387

        #4
        Can you post the runtime code? You should find it by looking at the properties of the runtime file.

        Comment

        • spulliam

          #5
          Looking at the msaccess.exe I see normal .exe properties…
          Looking at your database files I see normal data file properties…
          Because I cannot open the bases, I cannot see any access properties

          Comment

          • MMcCarthy
            Recognized Expert MVP
            • Aug 2006
            • 14387

            #6
            Normally if you right click on the runtime file and go to properties it will give you code for the running runtime file including path to the backend.

            Comment

            Working...