Linked tables 2000 from 2007

[boots3579]

I am trying to link tables from Access 2007 to Access 2000. I have done this because the 2000 file that I am trying to link to has some of tables from the same 2007 database.

 

[MajP]

If you want to link to access 2007 format tables from a system running Access 2000 then that is not possible. If you want an Access 2007 system to link to tables in an Acess 2000 database, then what is the question?

 

[boots3579]

I somehow have accdb tables linked from a 2007 Access db to an Access 2000 file format db. It shows up in the 2000 Access format as accdb. I have forgotten exactly what I did to allow the linkage.

 

[MajP]

There is no issue here it is the same as any other link.
Did you look at the help file

Prepare to link tables in an Access database
Locate the source database.
The file format can be MDB, MDE, ACCDB, or ACCDE. If the source database is password protected, you will be prompted to enter the password during the linking operation.

Identify the tables to which you want to link.
You can link to tables, but you cannot link to queries, forms, reports, macros, or modules.

If this is the first time you are linking to tables in another Access database, refer to the following table for some useful tips.

Element Description
Multiple objects You can create links to multiple tables in a single linking operation. A linked table is created for each source table.
Linked tables as source You cannot link to a table that is already a linked table in the source database.
For example, if the Employees1 table that you want to link to in the Sales database is actually a linked table that links to the Employees table in the Payroll database, you cannot use the Employees1 table in the Sales database as the source table. You should instead link directly to the Employees table in the Payroll database.

New or existing table Each linking operation creates a new linked table for each source table. You cannot overwrite or append to an existing table by using a linking operation.
Relationships If you select multiple source tables, the relationships between the tables are automatically carried forward to the destination database. However, you cannot change or delete the relationship in the destination database.
Lookup fields If a field in the source table looks up values in another table, you must remember to link to the related table if you want the destination field to display lookup values. If you do not link to the related table or query, the destination field only displays the lookup IDs.

Close the source database. Ensure that no other user has the database open in exclusive mode.
Open the destination database. Ensure that the destination database is not read-only and that you have the necessary permissions to add objects and data to the database.
Note If you want to create the links in a new database, you must create a blank database (one that does not contain any tables, forms, or reports) before starting the import operation.

Click the Microsoft Office Button , and then click New.

The operation does not overwrite or modify any of the existing tables or objects. If an object with the same name as the source object already exists in the destination database, Access appends a number (1, 2, 3, and so on) to the name of the linked table. For example, if you link to the Issues table from a database that already has a table named Issues, the linked table will be named Issues1. If the name Issues1 is already in use, the new table will be named Issues2, and so on.

Remember that if you want to append the records in the source table to a table in the destination database, you must use an append query instead of running a linking operation.

For more information about append queries, see the article Create an append query.
Link to the data
On the External Data tab, in the Import group, click Access.
Note The External Data tab is available only when a database is open.

In the File name text box, type the name of the source database or click Browse to display the File Open dialog box.
Click Link to the data source by creating a linked table, and then click OK.
In the Link Tables dialog box, select the tables you want to link to.
To cancel a selection, click the table again.

Click OK to finish the operation.
Access creates the linked tables.

Open the linked tables in Datasheet view to ensure that the data looks correct.