I discovered sqlite today and it looks promising. Many times in the past I've needed a lightweight, distributable database engine. Checking it out, I created a small, one table database, using the SQLite Database Browser. I installed the SQLite ODBC driver, set up a user DSN (My computer is running Windows 2000, by the way) and then attempted to access the table from Excel via Microsoft Query.

But when I attempt to open the database I receive a warning message: "This data source contains no visible tables."

I tried creating a couple more tables in different ways and they all show up using the Database Browser, but whenever I try to access them from Microsoft Query via ODBC I continue to be warned of no visible tables.

Could anyone suggest why my tables aren't being seen and what I can do so that they can be seen?


--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]



Reply via email to