Add new field to linked table

[Rob]

Hi, Using Access 2000 and have inherited an database that was written
several years ago by someone now unknown. What I need to do is add a couple
of extra fields to a table and then add these to an existing form.

My issue is that when the table is opened, I'm prompted with the message
that changes can't be made albeit I can go ahead and open but any changes
are not saved.

What do I need to do to open a linked table and add a new field?

Thanks, Rob

 

[Graham R Seach]

Rob,

You can't change a linked table. The database is split, meaning, there are
actually two databases; one containing all the forms, queries and so on, and
the other containing only tables.

You need to open the backend (the one containing the tables), and make the
changes there.

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia

 

[Rob]

Thanks Graham. Rob

Rob,

You can't change a linked table. The database is split, meaning, there are
actually two databases; one containing all the forms, queries and so on,
and the other containing only tables.

You need to open the backend (the one containing the tables), and make the
changes there.

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia