Problem adding a field to an existing Table

[Guest]

I am working on an existing database and would like to add a field to one of
it's table which I would then like to add to a form based on that Table.
Whenever I try to add the field I get a message saying "Table is a linked
table with properties that cannot be modified". Is there anyway for me to do
this without comprimising the database or the Table.

 

[Guest]

If it is a linked table, you need to go to the database file or system which
hosts this table. There you can add the field.

Now if it's something like SQL Server and the owners of the database will
not let you add the field, there is still hope. Create another table with two
fields. One will be the primary key field and needs to be the same data type
as the primary key field in the original table. The second field will be the
data you want to see.

Go to the Relationships Window and create a one-to-one relationship between
the primary keys of the two tables. Enforce Referiential Integrity.

Next join this table in all queries that use the orginal table. Now you'll
have the field that you want to see in the form.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Community Message Not Available

I am working on an existing database and would like to add a field to one of
it's table which I would then like to add to a form based on that Table.
Whenever I try to add the field I get a message saying "Table is a linked
table with properties that cannot be modified". Is there anyway for me to do
this without comprimising the database or the Table.

 

[Douglas J. Steele]

You have to make the change in the database where the table's actually
located.

 

[Guest]

When I attempt to join the two tables the system does not allow me to choose
Referential Integrity (RI). I created a subform and added it to the original
form but the new table is not picking up it's key from the original record.
It is just autonumbering sequentially. Is that related to the first problem
of not being able to select "RI". When I joined the files I got a message
saying that the new table would have a field added with the key of the
original table. I hope I'm not confusing the explanation. Please help if you
can.