Add another field into a linked table

[Guest]

NEED HELP, our programmer is gone!! I am needing to add another field into a
table that is linked and will not let any any changes to properties be made!
Is there any way to add this field?

 

[Douglas J. Steele]

Find the database where the real table is (i.e.: the database to which your
application is linked) and make the change there.

 

[Guest]

How do I find that database? I'm a newbie...I took an Access class so I only
know the basics and I just got this project because of the class...but the
programmer was a real wiz. Thank you!

 

[John Spencer]

Do you know how to get to the VBA window?

Open the database in design view
Type Control + G
In the immediate window Type the following and then press return
?CurrentDB().TableDefs("NameOfTheLinkedTable").Connect

Depending on how your database is set up that will return the full path to
the backend database.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Guest]

On the menu go to Tools, Database Utilities, Linked Table Manager. It should
say to where the tables are linked. Don't make any changes here. Just hit the
Cancel button.

Get everyone out of the database before making any changes and do a full
backup first of the FE and BE files. Also it's possible that the linked
tables aren't even in an Access database.

By programmer being gone, I assuming that you mean permenently. If you are
just a beginner with Access I'd be very careful before adding a field. It's
slightly possible that adding a field will break something such as an append
query.

Also the new field might not really be needed or already in another table
with a relationship to the table that you want to modify.

 

[Guest]

AWESOME! I found it! Thank you all for your help!