Re: SQL Problem

The Frog <Mr.Frog.to.you@xxxxxxxxxxxxxx> wrote:

The problem is that the Jet4.0 (Access 2000) type file cant be read by
Access97.

Try using MS DAO 3.6 in A97 instead of DAO 3.5. There was a posting a while back and
a very recent posting indicating this worked fine for the person.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
.

Relevant Pages

  • Re: Compact MDB back to Access 97 format with code?
    ... DAO 3.6 works fine with A97. ... The app tested OK and I only found out about the DAO 3.6 reference 2 years ... Tony Toews, Microsoft Access MVP ...
    (comp.databases.ms-access)
  • Re: DAO / ADO how do I know which Im using
    ... Microsoft Office 12.0 Access Database Engine Library is the Access ... Microsoft Access 12.0 Object Library ... None of the ADO or DAO items are checked. ... Is it possible that the four references listed initially provide all the ...
    (microsoft.public.access.gettingstarted)
  • Re: DAO / ADO how do I know which Im using
    ... Microsoft Access 12.0 Object Library ... None of the ADO or DAO items are checked. ... Is it possible that the four references listed initially provide all the ...
    (microsoft.public.access.gettingstarted)
  • Re: DAO vs ADO
    ... which makes DAO a good choice. ... >> against SQL Server to retrieve the data. ... >> add additional overhead by loading Jet, ... the Microsoft Access user interface, ...
    (microsoft.public.access.conversion)
  • Re: DAO vs ADO
    ... which makes DAO a good choice. ... >> against SQL Server to retrieve the data. ... >> add additional overhead by loading Jet, ... the Microsoft Access user interface, ...
    (microsoft.public.access.adp.sqlserver)