Stuart McLachlan
stuart at lexacorp.com.pg
Mon Apr 4 18:49:34 CDT 2011
I assumed that the query was the source of a DAO.recordset in VBA. But I was wrong once before, it's conceivable that I am again. -- Stuart On 4 Apr 2011 at 16:24, Charlotte Foust wrote: > Another possible reason is a multiple table query. Anyhow, queries > don't have AddNew and Update methods (although there are append and > update queries), so can you clarify what you're actually trying to do? > > Charlotte Foust > > On Mon, Apr 4, 2011 at 4:04 PM, Stuart McLachlan > <stuart at lexacorp.com.pg> wrote: > Hard to say without seeing the > query, but a common reason for a query being RO is that it > doesn't > include the PK of the table you are trying to update. > > -- > Stuart > > > On 4 Apr 2011 at 18:54, Ralf Lister wrote: > >> Hello, >> >> >> >> > I wanted to fill a Query with AddNew and Update. But I get the error > >> message " Error 3027 at run time./ You can't update. The database > a/o >> object is "read only"." What can I do to fix this problem? >> > >> >> >> TIA. >> >> >> >> Saludos >> >> Actuary Ralf Lister >> >> La > Paz, Bolivia >> >> >> >> -- >> AccessD mailing list >> > AccessD at databaseadvisors.com >> > http://databaseadvisors.com/mailman/listinfo/accessd >> Website: > http://www.databaseadvisors.com >> > > > > -- > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > Website: > http://www.databaseadvisors.com > -- AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd Website: > http://www.databaseadvisors.com >