Hi,

I want to open a access2000 database via ado. I managed to get it
running with access97, but not with 2000.
I tried to change the version from 3.51 to 3.6, but then i got a error
message: "runtime error: provider cannot be found. it may not be
properly installed"
but i have access2000 installed on my pc (and i am using vb 6.0 sp4).

And how can I manage that my program is working for access97 AND
access2000. Is there an easy way to find out, what type of version the
database is for and what version of access (jet enigine and ado) the
user has installed?

Greetings
                        Arno

Here comes the code, which is working for access97:

  Dim sConnect As String
  Dim dfwConn As New Connection

  sConnect = _
        "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security
Info=False;User ID=Admin;Data Source=" + GetSetting("Mapper", "Startup",
"KCPM-DB", "C:\kcpm-test.mdb") + ";Mode=Share Deny None;Extended
Properties=';COUNTRY=0;CP=1252;LANGID=0x0409';Locale Identifier=1033;Jet
OLEDB:System database='';Jet OLEDB:Registry Path='';Jet OLEDB:Database
Password='';Jet OLEDB:Global Partial Bulk Ops=2"

  'open connection
  Set dfwConn = New Connection
  dfwConn.Open sConnect
  dfwConn.Close

I have Acces 2000 to.
But I use version 6 of the MS jet OLE DB driver
ans then it works fine

you are rigth. but it still doesn't work
(i was confused with the number 3 in front of the oledb driver version).
i have problems using version 6.0.
But version 5.1 works great, but just for Access97:-(((

Any idea, what my problem could be (see my first message)

Greetings Arno