I currently have a access database which is link to a read only external
database via odbc.

What I am wanting to do is be able to add addtional data to these records in
my database
ie
The link brings in a list of reject no's against each of these numbers I
would like to add additional table columns for who created the problem, and
what shift they were created on.

Can I do this?

You could create a table in your Access database and join the two tables by
the primary key field in the linked table. Use a form based on the
primary/linked table and a subform for your table.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"The Rook" wrote:

> I currently have a access database which is link to a read only external
> database via odbc.
>
> What I am wanting to do is be able to add addtional data to these records in
> my database
> ie
> The link brings in a list of reject no's against each of these numbers I
> would like to add additional table columns for who created the problem, and
> what shift they were created on.
>
> Can I do this?