using linked sql tables in ms access

[abenitez77]

I have a form with a subform ("frmReturnsInvoice"). The form and subform uses 2 separate sql tables which I linked to my ms access application using dsnless linking. I have another form ("FrmHdrDatasheet") which my users initially go into which is in datasheet view. The users scroll thru the records and then they double click on a record on the "InvNbr" column. This opens up the second form ("frmReturnsInvoice") which contains the header and detail table. I am using a query to display the table results and I am putting this "Forms!frmHdrDataSheet!INVNBR" in my query so that it filters the view by the InvNbr selected. The app is on a different network than the sql database, so it is a bit slow to bring up and the hdr table is about 150,000 records and the dtl table is about 2.6 million records. The users will be editing the data directly from the form. What is the most effecient way to do this? I was thinking of doing a passthru query, but then the users will not be able to edit the linked table directly, right?

 

[dhookom]

I would make sure the appropriate fields are indexed. You are correct that a pass-through is read-only.

Duane
Hook'D on Access
MS Access MVP