ms-access-2003 - w3toppers.com

How to increase performance for bulk INSERTs to ODBC linked tables in Access?

This situation is not uncommon when dealing with bulk INSERTs to ODBC linked tables in Access. In the case of the following Access query INSERT INTO METER_DATA (MPO_REFERENCE) SELECT MPO_REFERENCE FROM tblTempSmartSSP where [METER_DATA] is an ODBC linked table and [tblTempSmartSSP] is a local (native) Access table, the Access Database Engine is somewhat limited in … Read more

create form to add records in multiple tables

The above design requires four subforms. Each subform should be based on the junction table with book id as the link child and master field and a combo box based on the relevant table for the second table id. For example, your first subform is Authors, the table it is based on is Libri_Autori Link … Read more