moving a back end database to another directory

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 ...

Answer 1

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

Answer 2

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

Answer 3

... and when i move back the backend database to the original directory, the i can open the front end again.

 

Answer 4

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

Answer 5

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

Answer 6

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

 

Answer 7

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 ?

Answer 8

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 ... ? 

Answer 9

It's an accdb, right? What versions are we talking about?

---

-Tom. Microsoft Access MVP

Answer 10

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 !

Answer 11

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