[AccessD] Error 3027

Thanks a lot Stuart,

The SQL is:

SELECT tblWerte.FechaCalculo, tblWerte.Nombre, tblWerte.Beneficiario,
tblWerte.Edad, tblWerte.Sexo, tblWerte.Densidad, tblWerte.TasaActualUSD,
tblWerte.TasaCompUSD, tblWerte.CC, tblWerte.PBR, tblWerte.LimSolInf,
tblWerte.MSR, tblWerte.PR, tblWerte.ValorAportes,
tblWerte.BeneficiosAltPension, tblDisposiciones.GF
FROM tblWerte, tblDisposiciones;


Saludos
Actuary Ralf Lister
La Paz, Bolivia

De: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] En nombre de Stuart McLachlan
Enviado el: Lunes, 04 de Abril de 2011 09:29 p.m.
Para: Access Developers discussion and problem solving
Asunto: Re: [AccessD] Error 3027

Can you post the SQL behind qryBeneficiosAlt?

--
Stuart

On 4 Apr 2011 at 20:42, Ralf Lister 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
>



--
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/3551 - Release Date: 04/05/11