none
moving a back end database to another directory RRS feed

  • Question

  • is that possible ? i ' 've split a database by the wizard . now i want to move the backend database to another directory, but then i can't open the frontend anymore ...
    Saturday, April 23, 2016 3:49 PM

Answers

  • You can open the FE by holding down the Shift key. That way the AutoExec macro does not run. Then use the Linked Table Manager to connect to the new location.


    -Tom. Microsoft Access MVP

    • Marked as answer by tekoko10 Saturday, April 23, 2016 9:10 PM
    Saturday, April 23, 2016 3:55 PM
  • That is really strange. Try this: Open Access first, then File > Open and navigate to the FE. Hold down the shift key while you select the file.

    -Tom. Microsoft Access MVP

    • Marked as answer by tekoko10 Sunday, April 24, 2016 4:22 PM
    Saturday, April 23, 2016 9:34 PM
  • Another thing to try: create a shortcut with

    [path_to]msaccess.exe [path_to]your.accdb /decompile

    also:

    [path_to]msaccess.exe [path_to]your.accdb /compact


    -Tom. Microsoft Access MVP

    • Marked as answer by tekoko10 Sunday, April 24, 2016 4:22 PM
    Saturday, April 23, 2016 10:18 PM

All replies

  • You can open the FE by holding down the Shift key. That way the AutoExec macro does not run. Then use the Linked Table Manager to connect to the new location.


    -Tom. Microsoft Access MVP

    • Marked as answer by tekoko10 Saturday, April 23, 2016 9:10 PM
    Saturday, April 23, 2016 3:55 PM
  • i can open the back end database but not open the linked table manager, and i can't open the frontend database. when i click the forntend , nothing happens

    Saturday, April 23, 2016 9:19 PM
  • ... and when i move back the backend database to the original directory, the i can open the front end again.

     

    Saturday, April 23, 2016 9:21 PM
  • That is really strange. Try this: Open Access first, then File > Open and navigate to the FE. Hold down the shift key while you select the file.

    -Tom. Microsoft Access MVP

    • Marked as answer by tekoko10 Sunday, April 24, 2016 4:22 PM
    Saturday, April 23, 2016 9:34 PM
  • Another thing to try: create a shortcut with

    [path_to]msaccess.exe [path_to]your.accdb /decompile

    also:

    [path_to]msaccess.exe [path_to]your.accdb /compact


    -Tom. Microsoft Access MVP

    • Marked as answer by tekoko10 Sunday, April 24, 2016 4:22 PM
    Saturday, April 23, 2016 10:18 PM
  • in this option all stays the same , i can open the BE and not the FE. when i open the frontend, access "blinks" but nothing happens

     
    Sunday, April 24, 2016 4:25 AM
  • unfortunately,  the shortcut with the path doesn"t work either

    i must say , it is a database i inherited and in it are some very old  access things ... can i have something to do with that ?

    Sunday, April 24, 2016 5:00 AM
  • Hallo Tom,

    I think that is the problem. I tried de splitting and moving  with one of my own databases and everything worked as it should be 

    the problem will be with the old database to find what causes the problems ... if you have any idea ... ? 

    Sunday, April 24, 2016 5:17 AM
  • It's an accdb, right? What versions are we talking about?

    -Tom. Microsoft Access MVP

    Sunday, April 24, 2016 3:50 PM
  • Yes , accdb And the oldest version is 1997 , i think. I've decoder not to do the werk for the client. Thedatabase is terrible, a lot of forms ,reportage, queries aren't used anymore The database relations aren't defiined properly .... In the forms there is no errorhandling.... So i"ll propose to begin from scratch , it wil Be a much compacter , But definitely more performant database . Thank hou very much for your time !
    Sunday, April 24, 2016 4:22 PM
  • Accdb implies Office 2007 or better. It may have started out with an older version but that is irrelevant. Even Access 2016 can open A2007 files.

    Yes, sounds like rewriting is the cheaper and better option.


    -Tom. Microsoft Access MVP

    Sunday, April 24, 2016 4:29 PM