Access 97 (dao) to 2003 (Ado)

From: John (y_at_spam.com)
Date: 08/28/04

  • Next message: William \(Bill\) Vaughn: "Re: SQL Relations vs. DataRelations?" 
    Date: Sat, 28 Aug 2004 18:25:57 GMT

    Can i use copy tables structure + data from Access97 to 2003 using ADO
    I do not longer need all the tables. Can i do this without creating first
    the tables?
    Do someone have an example. Is there a faq site for this NG

    Thx John.

  • Next message: William \(Bill\) Vaughn: "Re: SQL Relations vs. DataRelations?"

    Relevant Pages

    • Re: problem with WHERE clause when using ADO and Microsoft.Jet.OLEDB.4
      ... I am using ADO with Microsoft.Jet.OLEDB.4.0 to connect to the Access97 ... also had tried to convert the database from Access97 to Access2000 ... This email account is my spam trap so I ...
      (microsoft.public.data.ado)
    • Re: ADO/Delphi6/MsAccess - Memofields ..SOLVED
      ... in which I was reading was a Access97 table and the memo fields were> 64K. ... Access97 table using a DAO connection and then copy the contents into an ADO ...
      (borland.public.delphi.database.ado)
    • Re: problem with WHERE clause when using Microsoft.Jet.OLEDB.4.0
      ... I am using ADO with Microsoft.Jet.OLEDB.4.0 to connect to the Access97 ... is Index Yes with Duplicates OK, ... ADORecordset error, error code =80004005, code meaning = Unspecified error ... to convert the database from Access97 to Access2000 and upgrade the ADO ...
      (microsoft.public.access.queries)