J
jberrie
When I use the Link Table Manager it is not displaying any of the 75 linked
tables in the database.
tables in the database.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Raghu Prakash
Hi,
Troubleshooting Microsoft Access Databases: Copying a Linked Table
Source of the Problem
You've been using the data in a very helpful table that's actually located
in another database. In order for the data to be maintained in the source
database, you decided to link to the table instead of importing it into
your own database. Now you find that having your own copy of the table in
your database would be better, so you create a copy of the table. You use
the Copy and Paste commands on the Edit menu as well as the Save As command
on the File menu, but when you look at the list of tables in the database
window, you can tell by the link icon that the table is still linked to the
original database and is not a stand-alone copy
The problem is that you are copying only the link. You need to use a
different method to construct a table based on the linked table. The
following solution shows you how to use the special purpose make-table
query to create the local table.
How to Fix It
Open your database with the link to the table you want to make a copy of.
Click Queries in the Objects list, click New, and then choose Design View
in the New Queries dialog box. Click OK.
In the Show Table dialog box, select the linked table, click Add, and then
click Close.
From the field list, drag the asterisk to the query design grid
On the Query menu, click Make-Table Query.
In the Make Table dialog box, enter a name for the new table in the Table
Name box
Click Current Database, and then click OK.
On the Query menu, click Run.
Click Yes when asked to confirm that you want to create a new table and
paste the records in it.
Close the query without saving it. You will not need to run it again.
Return to the database window and click Tables in the Objects list. Look at
the list of tables to see the new table object
In the list of tables, select the linked table and then click Delete on the
Edit menu.
Note: Deleting a linked table object from the database window removes only
the link to the table. The original source table is unaffected.
For Further Information :
http://www.microsoft.com/learning/books/troubleshooting/access/LS/022102.asp
View, refresh, or change the file name and path for linked tables (MDB)
http://office.microsoft.com/en-us/assistance/HP051876231033.aspx
Please let me know has this helped You...
Thank you...
Raghu...
This posting is provided "AS IS" with no warranties, and confers no rights.
Troubleshooting Microsoft Access Databases: Copying a Linked Table
Source of the Problem
You've been using the data in a very helpful table that's actually located
in another database. In order for the data to be maintained in the source
database, you decided to link to the table instead of importing it into
your own database. Now you find that having your own copy of the table in
your database would be better, so you create a copy of the table. You use
the Copy and Paste commands on the Edit menu as well as the Save As command
on the File menu, but when you look at the list of tables in the database
window, you can tell by the link icon that the table is still linked to the
original database and is not a stand-alone copy
The problem is that you are copying only the link. You need to use a
different method to construct a table based on the linked table. The
following solution shows you how to use the special purpose make-table
query to create the local table.
How to Fix It
Open your database with the link to the table you want to make a copy of.
Click Queries in the Objects list, click New, and then choose Design View
in the New Queries dialog box. Click OK.
In the Show Table dialog box, select the linked table, click Add, and then
click Close.
From the field list, drag the asterisk to the query design grid
On the Query menu, click Make-Table Query.
In the Make Table dialog box, enter a name for the new table in the Table
Name box
Click Current Database, and then click OK.
On the Query menu, click Run.
Click Yes when asked to confirm that you want to create a new table and
paste the records in it.
Close the query without saving it. You will not need to run it again.
Return to the database window and click Tables in the Objects list. Look at
the list of tables to see the new table object
In the list of tables, select the linked table and then click Delete on the
Edit menu.
Note: Deleting a linked table object from the database window removes only
the link to the table. The original source table is unaffected.
For Further Information :
http://www.microsoft.com/learning/books/troubleshooting/access/LS/022102.asp
View, refresh, or change the file name and path for linked tables (MDB)
http://office.microsoft.com/en-us/assistance/HP051876231033.aspx
Please let me know has this helped You...
Thank you...
Raghu...
This posting is provided "AS IS" with no warranties, and confers no rights.
H
Hank
Hi jberrie.
You may want to review MS Knowledge Base Article 835519. There is a bug in
Access 2003 with the description "List of currently linked tables may not
appear in Linked Table Manager Wizard in a database in Access 2003." I had
the same problem. They do provide a resolution, but in it you have to run a
command prompt and they don't tell you to put quotes around teh
<path>\Accwiz.ddl.
Hope this helps.
You may want to review MS Knowledge Base Article 835519. There is a bug in
Access 2003 with the description "List of currently linked tables may not
appear in Linked Table Manager Wizard in a database in Access 2003." I had
the same problem. They do provide a resolution, but in it you have to run a
command prompt and they don't tell you to put quotes around teh
<path>\Accwiz.ddl.
Hope this helps.
H
Hank
You will also find a lot more questions/answers on linked tables in the
"Access Import/Export Data" rather than "Access General Questions". Hope this
helps.
"Access Import/Export Data" rather than "Access General Questions". Hope this
helps.