used it, but I know that there is an ODBC driver for SQLite,
so
that may satisfy your needs for using the Access front-end, integrating with
other
applications, etc.
Allan Miller
- Original Message -
From: "Allan, Mark" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, S
On Wed, 6 Sep 2006 18:05:36 +0100, you wrote:
Hello Mark
I think, either Access or ODBC is not a real good idea.
SQLite is a real good idea, if you need a small embedded database.
So far as I know, its even not a good idea, to compare MySQL and
Postgres to SQLite, because MySQL is a Client/Ser
> -Original Message-
> From: Allan, Mark [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 06, 2006 10:06 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] SQLite vs MS Access
>
> Hi,
>
> After successfully using SQLite on an embedded device, we a
On 9/6/06, Allan, Mark <[EMAIL PROTECTED]> wrote:
Hi,
This would be used in place of an MS Access database on a local/network disk. I
believe that SQLite should be quicker for both transactions and queries than
Access. The one draw
I've repeatedly seen database corruption with Access in mu
Sqlite is far more portable than Access. There is also an ODBC
interface available so that you can use the standard SQL/CLI API.
Just be wary of the fact that Sqlite does not have a server like
PostgreSQL so you may run into some locking situations if you have your
database distributed across
--
From: "Allan, Mark" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, September 06, 2006 1:05 PM
Subject: [sqlite] SQLite vs MS Access
Hi,
After successfully using SQLite on an embedded device, we are now thinking of
using SQLite in a PC application.
This would be used in place of a
Mark,
If you looking for accessibility to your SQLITE DB from within other windows
applications (That support ODBC) then there is an ODBC driver for SQLITE
which is probably the most common manner to access databases.
Take a look at the following link.
http://www.ch-werner.de
What level of access is needed from outside of the application? There are
nice GUIs available for SQLite that people could use. There is in theory
ODBC access as well, although my experience with ODBC and SQlite was not
especially happy.
Clay
Allan, Mark said:
> Hi,
>
> After successfully using
On 9/6/06, Allan, Mark <[EMAIL PROTECTED]> wrote:
Hi,
After successfully using SQLite on an embedded device, we are now thinking of
using SQLite in a PC application.
This would be used in place of an MS Access database on a local/network disk. I
believe that SQLite should be quicker for both
Hi,
After successfully using SQLite on an embedded device, we are now thinking of
using SQLite in a PC application.
This would be used in place of an MS Access database on a local/network disk. I
believe that SQLite should be quicker for both transactions and queries than
Access. The one draw
10 matches
Mail list logo
