I am trying to build Access frontend interface to Oracle database. Initially I created linked tables and everything worked perfect. But since I wanted to have option to connect both main and test database (both used regularly), I used MSDAORA connection. Now I can access both database using login form, But I am facing problem in Master-child form. I am able to make changes in SITE table (Master) but not SITECHECK (Child Table). The query I am using is
SITECHECKS table is result of many to many relationship between tables SITES and MEASURAND.
The message I am receiving is 'The recordset is not updatable'. The same things works using linked tables but not using connection string with MSDAORA.
Can you please help me so that I can add data to SITECHECKS table using MASTER CHILD form.
Thanks in advance
Code:
strSQL = " SELECT HYDRO.SITECHECKS.*, HYDRO.SITES.SITE_NAME, HYDRO.MEASURANDS.MEASURAND" & _
" FROM (HYDRO.SITES INNER JOIN HYDRO.SITECHECKS ON HYDRO.SITES.SITEID = HYDRO.SITECHECKS.SITEID) " & _
" INNER JOIN HYDRO.MEASURANDS ON HYDRO.SITECHECKS.MEASURANDID = HYDRO.MEASURANDS.MEASURANDID " & _
" WHERE HYDRO.SITECHECKS.MEASURANDID=" & MEASURAND & " ORDER BY HYDRO.SITECHECKS.SITEID"
The message I am receiving is 'The recordset is not updatable'. The same things works using linked tables but not using connection string with MSDAORA.
Can you please help me so that I can add data to SITECHECKS table using MASTER CHILD form.
Thanks in advance