Anthony (or is it Zach??) I'm assuming you're using windows if you are running MS Access. The database used by Slimserver is SQLlite 3.
Download the Windows ODBC driver here http://www.ch-werner.de/sqliteodbc/sqliteodbc-win32-0.64.zip and install it on your system. It will install 3 drivers, i.e. SQLLite3,SQLLite2 & SQLLite 2 UDF Then create an ODBC DSN called "SlimDB" using the SQLlite 3 driver pointing at this file C:\Program Files\SlimServer\server\Cache\slimserversql.db Once this is done, you can create a new Db in MSAccess Then do File->Get External Data->Import In the file selector, change "Files of Type" to ODBC Databases, and choose the SlimDb DSN you created. You should then be able to import all the tables from the Slimserver Db. By the way. Shut down the Slimserver while doing this as I think SQLlite only support Db level locking, so you'll probably get errors if the database is in use by any other app while you try the import. I've also imported into SQL server and looked at using indexes etc on the tables, but my perl isn't up to the conversion work required. -- oreillymj _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/beta
