Adding New Record to a linked table from Query

S

Steve Stad

Is it possible to add a new record to a linked table from a query.
eg. Add new data record to table1 in db1 from a select qry in db2 on the
linked table1. I can edit existing data records but can not add new records.
The new record button is greyed/inactive when I click on the new blank record
in the qry in db2?
 

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

Similar Threads

Using Append Queries with Linked Tables 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Access Access Daisy Chain Linked Tables 0
Combine and Insert query 7
Use Update Query to Add Fields 1
Problem with Cross qry 1
Referential Integrity on Linked Tables 3
Want last record only from a 1 to many linked table. 3

Top