First I want to greet everybody over here... I just registered at the forum and I haven't been able to contribute at this forum yet. Though I hope that someone is able to help me with my problem.
I'm migrating some old access-databases to 2007 format. I do this with Access 2010 32 bits. It's a split database with a fore-end (GUI) and a backend (tables), both access. The tabled are accessed in the GUI by linked tables.
So far so good... I made some changes and everything seemed to work fine. I took both databases with me to the customer to install the new versions on their environment and what happened... there was no way to open the GUI-database. With or without touching the shift button, it wasn't doing anything. By opening the database, it directed me to the start screen of Access without opening anything.
First I thought it was because their version of Access was Dutch, while I working in an English version of Access. But some small tests made clear that that wasn't the problem. By accident I found what the actual reason was. On my own enviroment, I renamed the backend and found out that the fore-end wasn't starting in my environment anymore as well.
So it seems that whenever the backend isn't at the position the fore-end expects it to be.... it just refuses to do anything. It doesn't give you the chance anymore to relink either.
I figured out that by deleting the tables and relink them at my customer's environment will probably solve this problem, but this behaviour - in my eyes - is a bit weird. Is there another work around to solve this problem. Does anybody know if there's a possibility to relink the tables, although the database doesn't start?
Just curious if someone else faced the same problems....