Adding data to a linked database

  • Thread starter Thread starter The Rook
  • Start date Start date
T

The Rook

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.
 
Back
Top