Hi All,

Im tyring to use excel 2002 on XP to access an sqlite database.
I have a test database called Test.db with one table, containg three columns
and several lines of data.

I've installed the sqlite odbc drivers from
http://www.ch-werner.de/sqliteodbc/
I've then created a datasource via the ODBC Data Source Administrator window.

I found the following code to see if i can access the database:

Sub TestDB()
Dim ws As Workspace
Dim con As Connection
Dim rs As Recordset

Set ws = DBEngine.CreateWorkspace("ws1", "", "", dbUseODBC)
Workspaces.Append ws
Set con = ws.OpenConnection("con1", dbDriverComplete, False,
"ODBC;DSN=TestDB1")
Set rs = con.OpenRecordset("select * from TabPerson")

With rs
Do While Not .EOF
MsgBox .Fields(0)
..MoveNext
Loop
End With

rs.Close
con.Close
ws.Close
End Sub


However when i run it i get the following error:

Run-time error '0':
IM001: [Microsoft][ODBC Driver Manager] Driver does not support this function


I have the following References selected:
Microsoft DAO 3.6 Object Library

Is anyone able to help on this? I've search through google for an answer to
the error message and for alternative code. Basically I am trying to develop
an entry form which will store the data in sqlite, then have a few report
macro's to pull data out.

Thanks Heaps.
Tony Z.