Solved

Paths are too long to read in Linked Table Manager

Posted on 2004-04-20
7
267 Views
Last Modified: 2013-12-03
Access 2000
Updating linked tables in Linked Table Manager. The path names to the old tables are too long to read in the provided window and I am unable to resize it to read them. Thus i am not sure what tables to re-link them to. Is there any way of viewing the full path names?
0
Comment
Question by:buzzbuzz0
7 Comments
 
LVL 34

Expert Comment

by:flavo
ID: 10875113
In the mySysObject system table, it holds this info

Databse field holds the locaiton

ForigenName holds to table

Dave!
0
 
LVL 11

Expert Comment

by:sparab
ID: 10875345
Go to Tools>Database utilities>Linked Table manager.

Here you can find Table name and full path of your database.

Regards
Sparab
0
 
LVL 34

Expert Comment

by:flavo
ID: 10875350
sparab,

They tried that
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 34

Expert Comment

by:flavo
ID: 10875701
To show hidden tables go to Tools -> options -> select the view tab and turn on view hidden objects / system objects
0
 
LVL 32

Expert Comment

by:jadedata
ID: 11308221
I've always hated this about the Table Attachment Wizard and tools....  

To beat this I will occasionally map a drive to the lowest level folder to be able to shorten the link path length, or share the datafolder and use a UNC type link reference.
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 11344460
PAQed - no points refunded (of 125)

modulo
Community Support Moderator
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now