Adding data to a linked database

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?
 
J

Jerry Whittle

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top