Re: Make all records as changed
From: Frank Hickman [MVP] (fhickman_NOSP_at_M_noblesoft.com)
Date: 02/24/05
- Next message: Frank Hickman [MVP]: "Re: Copy between identcal tables"
- Previous message: Olivier: "How works MaxRecords attribut ?"
- In reply to: Alexander Baumgart: "Make all records as changed"
- Next in thread: Val Mazur: "Re: Make all records as changed"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 24 Feb 2005 04:29:10 -0500
"Alexander Baumgart" <Alexander.Baumgart@siemens.com> wrote in message
news:cvk35s$kmk$1@mail1.sbs.de...
> Hello,
>
> i try to copy a Access DB to a SQL Server per ADO. I create a identical
> table on both DBs and was hoping i could simple open a recordset
> on the Access DB change the activeconnection to the SQL Server and force
> an
> update. But that didnt work because alle records get the status/editmode
> unchange, that i didnt seem couldnt change ;( Any idea how i could copy
> alle
> data between the 2 dbs ?
>
>
Since your using ADO then you should look at using the SetAllRowStatus
method. Other database technologies should have something comparable.
-- ============ Frank Hickman Microsoft MVP NobleSoft, Inc. ============ Replace the _nosp@m_ with @ to reply.
- Next message: Frank Hickman [MVP]: "Re: Copy between identcal tables"
- Previous message: Olivier: "How works MaxRecords attribut ?"
- In reply to: Alexander Baumgart: "Make all records as changed"
- Next in thread: Val Mazur: "Re: Make all records as changed"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
