[AccessD] Error 3027

You actually want to add data to tables, so why try to use the query
to do so?  In any case, if it isn't updateable it's usually because of
the structure of the query.  However, in your case, depending on the
version of Access you're using, you haven't declared a recordset type,
so your recordset may be a snapshot, which is not updatable by
definition, regardless of whether the query is.

Charlotte Foust

On Mon, Apr 4, 2011 at 5:42 PM, Ralf Lister <rlister at actuarial-files.com> wrote:
> Thank you all for your help.
>
>
>
> Charlotte, I`m gathering information data about one person, make some
> calculations  and save this calculations in the fields of a query by
>
>
>
> Set dbs = CurrentDb
>
> Set rst = dbs.OpenRecordset("qryBeneficiosAlt")
>
>
>
> With rst
>
>    .AddNew
>
>    ![FechaCalculo] = Now
>
>    ![Nombre] = gstrNombre
>
>    ![Beneficiario] = gstrBeneficiario
>
>    ![Edad] = gintEdad
>
>    ![Sexo] = gstrSexo
>
>    ![Densidad] = gintDensidad
>
>    ![TasaActualUSD] = gsngTasaActualUSD
>
>    ![TasaCompUSD] = gsngTasaCompUSD
>
>    ![CC] = gsngCC ' CC = Compensacion de Cotizaciones
>
>    ![PBR] = gsngPBR ' PBR = Pension Base Referencial
>
>    ![LimSolInf] = gsngLimSolInf
>
>    ![MSR] = gsngMSR ' MSR = Monto Salarial Referencial
>
>    ![PR] = gsngPR ' Porcentaje Referencial
>
>    ![BeneficiosAltPension] = gsngBeneficiosAltPension
>
>    ![ValorAportes] = gsngValorAportes
>
>    ![GF] = gsngGF
>
>    .Update
>
> End With
>
>
>
> to be able to make a report on this very query as a Control Source. After
> printing the report I delete the data in the query with "DoCmd.RunSQL
> "DELETE FROM qryBeneficiosAlt"" and the whole thing begins again.
>
>
>
> But at "AddNew I get this error message " Error 3027 at run time./ You can't
> update. The database a/o  object is "read only"."
>
>
>
> Saludos
>
> Actuary Ralf Lister
>
> La Paz, Bolivia
>
>
>
> De: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] En nombre de Charlotte Foust
> Enviado el: Lunes, 04 de Abril de 2011 07:24 p.m.
> Para: Access Developers discussion and problem solving
> Asunto: Re: [AccessD] Error 3027
>
>
>
> 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
>
>  _____
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 10.0.1209 / Virus Database: 1500/3550 - Release Date: 04/04/11
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>