If anyone manages to get the SQLite ODBC Driver to work on XP Pro with a late version of Office (I'm using 2003 here) could they post a "how to" here?
I copied slimserversql.db to my desktop (so I did not screw up the original one), created a SQLite3 User DSN via Administrative Tools/Data Sources with a path to the db file on my desktop and a friendly name (I assume Data Source Name is a friendly name thing), put Lock Time Out to 1000 seconds (gained from SQLite ODBC Driver readme.txt). Ignored the two check boxes. When I opened slimserversql.db in MS Access I received the message "MS Jet Database Engine could not find the object "slimserversql.db". Make sure the object exists and you spell it's name and the path name correctly". As I never typed any names or paths (used browse function) the message didn't help. The associated Help File is blank (thanks MS). I then tried changing the User DNS to aim at C:\Program Files\SlimServer\server\Cache\slimserversql.db and then tried opening the db in Access and Excel but received the same result. MC -- ModelCitizen _______________________________________________ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
