Linked Table Manager in ACCESS

[Richard]

Hi,

I am trying to change a field in an ACCESS table and get an error message
that says the table is a linked table and fields can't be changed. After
googling for some answers, I think I should be able to find out the link
using "Linked Table Manager" in ACCESS. However, the "Linked Table Manager"
button is grayed out. Any ideas/suggestions are welcome.

Thanks.

Richard

 

[S.Clark]

Open the table in Design View. Reduce the window so that you can see the
window's top bar. Right click in the top bar of the window (usually blue in
color) and select 'Properties'. There is a property in there that will tell
you exactly where it is linked.

 

[Gina Whipp]

Richard,

Before you embark on changing a field, is this an MDE database? The reason
I ask is because you say the Linked Table Manager button is greyed out. And
if it is a MDE then you won't be able to update the forms. So you chould
investigate that before making any changes.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[John Spencer]

You can get the location of the table using the following in the immediate
window of the VBA.

Enter the following and press return. It should return the connect string
which will have the full path to the back end database where that table exists.
?Currentdb.TableDefs("Name Of the Table").Connect



John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[Armen Stein]

And even in databases where Linked Table Manager isn't available, our
J Street Access Relinker will work. You're welcome to download it for
free from:
http://www.jstreettech.com/downloads

It handles multiple Access back-end databases, ignores ODBC linked
tables, and can automatically and silently relink to back-end
databases in the same folder as the application (handy for work
databases or single-user scenarios). There's a ReadMe table with
instructions.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com