Program will only work in one location..

[freddiel]

I have taken over the IT support for a company and they have a few Access Apps.

The problem is that when I install a new computer with Vista/Windows 7 the application will not work. The Application seem to have been hard coded to only work in the following location;

C:\Documents and Settings\Administrator\My Documents

This is not only a pain as most users have a different user account, but even if I activate the Administrator account and put the file in this location, Windows 7 does not want to let the program run.
Access reports file not found at the location above.
I did manage to make it work on one Vista computer, but I could do with removing this restriction.

Is there a good method for removing this hard coded link?

Thanks.

 

[DCrake]

What condition are the apps in?

Compiled?
rRuntime?
Do you have development rights?
ULS in use?
Is the application split FE/BE?

 

[freddiel]

The program requires access to be install and compromises of two MDB files, one seems to be the Dashboard and the other the data.
I have not asked the clients if they have the development rights, but the startup screen states he has copyrights.
Does not look like they use ULS. It is a single user in two locations (office home) and no username/login is required.
I can browse the data.

Any help / suggestions welcomed

 

[DCrake]

What this is saying is that the database you are trying to open has linked tables. It is split between front end and back end. The link table manager has been used to point to the back end tables. You can tell this because there are small arows to the left of the table names.

Now what has happened is that you have given the front end to someone who does not have that path on their machine. In any case the back end should be stored on a central server, thus allowing all users to have access to it.

Copy the back end to the server then use the link table manager to re link the tables to the server.

 

[freddiel]

That all sounds so easy David, unfortunately I a bit lost with regards to what to do?

As far as I know there is only two files, both are sat in the same folder, just move to another location. I have open it an looked for "link manage tables" both in menu and help but no luck.

I am working on the data in Access 2007, which may be different to 2002/3?

 

[DCrake]

Open the Dashboard up whilst holding down the Shift key. Then choose Database Tools from the main ribbon and look for Link table manager. It is in the 5th group and has a recycle icon on it. Follow the steps there to relink the dashboard data tables.

 

[freddiel]

Thanks a million David, that did the trick. I have from time to time people presenting issues like this to me and since it is about 15 years since I did database programming in FoxPro I do find it difficult. I have little real experience with Access. Is there a quick fix to this, i.e. Access for Dummies or something else that will make me feel more at home?