Make all records as changed

From: Alexander Baumgart (Alexander.Baumgart_at_siemens.com)
Date: 02/24/05 

Date: Thu, 24 Feb 2005 09:27:40 +0100

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 ?

Relevant Pages

  • Re: Make all records as changed
    ... > i try to copy a Access DB to a SQL Server per ADO. ... But that didnt work because alle records get the status/editmode ... Since your using ADO then you should look at using the SetAllRowStatus ...
    (microsoft.public.data.ado)
  • Re: Make all records as changed
    ... There is no direct way to change status of the records in ADO recordset, ... > table on both DBs and was hoping i could simple open a recordset ... But that didnt work because alle records get the status/editmode ...
    (microsoft.public.data.ado)
  • Re: public role???
    ... account existed for all these DBs. ... these users from viewing the master and tempdb DBs as well? ... then that's the way SQL Server ... >see if you have the "guest" account enabled in the other ...
    (microsoft.public.sqlserver.security)
  • Re: Suggested DB Reverse Engineering tool...
    ... many many development DBs ... on the market are PowerDesigner, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: public role???
    ... What exactly do you mean by "new users have access to all DBs"? ... If you mean that new users can see the names of the other databases, ... Documentation on the "guest" account is available in the SQL Server Books ... > permissions. ...
    (microsoft.public.sqlserver.security)