Can't update recordset after append new record in SQL70 from MSAccess 97(DAO)

Can't update recordset after append new record in SQL70 from MSAccess 97(DAO)

Post by George Lablju » Fri, 30 Apr 1999 04:00:00



After have been created some records from MS Access 97 (OpenRecordset DAO)
to SQL70 database :
For lngTemp = Polises_No To Polises_Lidz Step 1
With rstApdrXX
        .AddNew
        !PIEGADATAJS_ID = Me!Piegadatajs
        !PIEGADES_DATUMS = Me!PiegDatums
        !SERIJA = Me!ApdrVeids.Column(2)
        !AGENT_CODE = ""
        !NUMURS = lngTemp
        !PAZIME = 0
        !OPER_KODS = Forms![Startup]![Operator]
        .Update
    End With
Next lngTemp

I can't use
For lngTemp = Polises_No To Polises_Lidz Step 1
    With rstApdrXX
        .Edit
        !IZSNIEGSANAS_DATUMS = Me!IzsnDatums
        !SANEMTS_NO_AGENTA = Null
        !AGENT_CODE = Me!Agents
        !PAZIME = 1
        !OPER_KODS = Forms![Startup]![Operator]

        .Update        !!!!!!!!!!!!!!!!! this record has been changed by
another user since you started editing it ?????

        .MoveNext
    End With
Next lngTemp

Help me pleaseeeeeeeeeee!!!

 
 
 

Can't update recordset after append new record in SQL70 from MSAccess 97(DAO)

Post by George Lablju » Fri, 30 Apr 1999 04:00:00


After have been created some records from MS Access 97 (OpenRecordset DAO)
to SQL70 database :
For lngTemp = Polises_No To Polises_Lidz Step 1
With rstApdrXX
        .AddNew
        !PIEGADATAJS_ID = Me!Piegadatajs
        !PIEGADES_DATUMS = Me!PiegDatums
        !SERIJA = Me!ApdrVeids.Column(2)
        !AGENT_CODE = ""
        !NUMURS = lngTemp
        !PAZIME = 0
        !OPER_KODS = Forms![Startup]![Operator]
        .Update
    End With
Next lngTemp

I can't use
For lngTemp = Polises_No To Polises_Lidz Step 1
    With rstApdrXX
        .Edit
        !IZSNIEGSANAS_DATUMS = Me!IzsnDatums
        !SANEMTS_NO_AGENTA = Null
        !AGENT_CODE = Me!Agents
        !PAZIME = 1
        !OPER_KODS = Forms![Startup]![Operator]

        .Update        !!!!!!!!!!!!!!!!! this record has been changed by
another user since you started editing it ?????

        .MoveNext
    End With
Next lngTemp

Help me pleaseeeeeeeeeee!!

 
 
 

1. Appending records to a DAO recordset

Hello,

I'm trying to run a SQL query against multiple tables (with the same
structure) within an access database and come up with a single
recordset. I've searched for ways to append the records but can't seem
to find one. I have no problem appending to an actual table but I just
want a recordset.

Thanks,
RWK

Sent via Deja.com http://www.deja.com/
Before you buy.

2. Pdox4.5 Dos, Win95, & Novell 3.03? Printing problems

3. Can't append new records to a table of

4. pg_dump and timestamp : problem with TimeZone

5. MSAccess 97, SQL Server 7, Linked Tables and Cascading Updates

6. Need help about installing/running MSSQL & SybaseSQLAnywhere on same server

7. msaccess'97 jdbc driver

8. DbiDoRestructure more information?

9. parametric search engine for msaccess' 97

10. Appending records from Access 97 tables in SQL tables

11. Appending records from an Access 97 table

12. Can't append excel 97 worksheet to Access 2.0 database using VB 4.0

13. trouble Appending records to attached DBF table (ACC 97)