[AccessD] Error 3027

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
> 






More information about the AccessD mailing list