MC, this worked for me on XP/SP2 - Access 2003 1. Using the Administrative Tools / Data Sources option - select the System DSN tab and configure (or add another) a SQLite3 source pointing to your copy of the db.
2. Open Access and create a new blank database, use the menu options: File - Get External Data - and either Import or Link Tables (as you prefer). In the dialogue box that opens set file type to ODBC(). This should open a Select Data Source dialogue box. Select the tab 'Machine Source' - click on the source you configured in 1. Click OK (I used 1000 msec as a time out). 3. Select the tables you want to link to in the dialogue that appears and click OK - the tables you want will appear in the Access database control. 4. The relations between the tables will not come over, but if you link rather than import the table specific indexes and keys seem to be preserved (all are lost if you import). Happy querying Chris -- lostboy _______________________________________________ Discuss mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/discuss
