Re: DAO to ADO and stored procs

I would concur with the previous response. Access SQL is not your
Father's SQL (US joke). There are many, shall we say, nuances about
Access SQL. Just trial and error. Still, though, I am a bit surprised
ADO is causing so many issues. Perhaps the DAO sytanx was more off and
now with ADO, the problems are surfacing.

I know when I had to write for multiple databases, DB2, Oracle, MSSQL,
and Access, I frequently had to "tweak" the SQL for Access' sake.

.

Relevant Pages

  • Using .FILTER
    ... I have a JET table that I'm trying to access through Visual Basic 6 using ADO. ... I run the following code and it filters the correct records for me ... I then tried the following code and I got a 3001 error message ... ... statement worked in MS Access SQL but I can't seem to find any ...
    (microsoft.public.vb.database.ado)
  • SQL Mobile 3.0 through ADO: CE and desktop support
    ... I was able to access SQL CE 3.0 on CE via ADOCE. ... And even on desktop via ADO 2.8 but only after I called regsvr32 on a pair ...
    (microsoft.public.sqlserver.ce)