Link Table to Another Access Database

[Milan Mehta]

I am developing one application in Access 2007. My database is in a seperate file and I have created one more file in which I keep all the forms, reports etc. apart from link to tables in the previous database.

My problem is it works fine on my computer but when I try to access the database from another computer, the linked table link fails. The reason is it is linked to D:\ABC\XYZ.ACCDB. But while accessing from network D:\ will be its local drive.

I think everyone must have faced this problem. I am new to Access. Can someone guide ?

TIA
Milan.

[hjozinovic]

Hi Milan!

Have you tried to read help in Access2007?
You must link your tables from every computer separately.
this is what I found in Access2003 help:
View, refresh, or change the file name and path for linked tables (MDB)
Show All
Hide All
Note The information in this topic applies only to a Microsoft Access database (.mdb).

You can link (link (tables): An action that establishes a connection to data from another application so that you can view and edit the data in both the original application and in Access.) a table only in a Microsoft Access database (Microsoft Access database: A collection of data and objects (such as tables, queries, or forms) that is related to a particular topic or purpose. The Microsoft Jet database engine manages the data.), not a Microsoft Access project (Microsoft Access project: An Access file that connects to a Microsoft SQL Server database and is used to create client/server applications. A project file doesn't contain any data or data-definition-based objects such as tables and views.).

View or refresh links

Use this procedure to view or to refresh links when the structure or location of a linked table has changed. The Linked Table Manager lists the paths to all currently linked tables.
Open the database that contains links to tables.
On the Tools menu, point to Database Utilities, and then click Linked Table Manager.
Select the check box for the tables whose links you want to refresh.
Click OK to refresh the links.
Microsoft Access confirms a successful refresh or, if the table wasn't found, displays the Select New Location of <table name> dialog box in which you can specify the table's new location.

If several selected tables have moved to the new location that you specify, the Linked Table Manager searches that location for all selected tables, and updates all links in one step.

To change the path for a set of linked tables

Open the database that contains links to tables.
On the Tools menu, point to Database Utilities, and then click Linked Table Manager.
Select the Always prompt for new location check box.
Select the check box for the tables whose links you want to change, and then click OK.
In the Select New Location of <table name> dialog box, specify the new location, click Open, and then click OK.
Notes

The Linked Table Manager doesn't move database or table files. For information about moving database or table files to a new location, search Microsoft Windows Help. Once you have moved a database or table, you can use the Linked Table Manager to refresh links.
The Linked Table Manager can't refresh links to Microsoft Access tables whose names were changed after they were linked. You must delete the current link, and then link such tables again.

[ramdil]

HI
If u r developing this application and should be accessed by others also,
then its better to deploy that Front end and Back end versions in a server and find a short cut to your machine or some other machine.I think it will solve your issues

Dilip

I am developing one application in Access 2007. My database is in a seperate file and I have created one more file in which I keep all the forms, reports etc. apart from link to tables in the previous database.

My problem is it works fine on my computer but when I try to access the database from another computer, the linked table link fails. The reason is it is linked to D:\ABC\XYZ.ACCDB. But while accessing from network D:\ will be its local drive.

I think everyone must have faced this problem. I am new to Access. Can someone guide ?

TIA
Milan.