[AccessD] [dba-Tech] SQLite

It's also pretty well the default database for iOS and OSX.




On Wed, Feb 5, 2014 at 1:06 PM, Stuart McLachlan <stuart at lexacorp.com.pg>wrote:

> SQLite is a single user, embedded database engine. It is the default
> engine which comes on
> all Android devices.  In Windows, it is a single DLL.
>
> I've written several applications for transferring data between Access/SQL
> Server and
> SQLite.(using PowerBASIC) for moving data between tablets and Windows, but
> not
> interfaced with it directly through Access.  The problem is that Access is
> multi-user and
> SQLite is single user.
>
> If your Access application is single user, you can download and instal the
> SQLite3 ODBC
> driver and  then just use your SQLIte database file as an ODBC source, but
> be very careful if
> it is multi-user.
>
>
> On 5 Feb 2014 at 12:13, Jim Lawrence wrote:
>
> > Hi All:
> >
> > I have just been asked to connect SQLite to an Access DB. Has anyone
> > had any experience with this product?
> >
> > http://www.sqlite.org/
> >
> > Jim
> > _______________________________________________
> > dba-Tech mailing list
> > dba-Tech at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-tech
> > Website: http://www.databaseadvisors.com
> >
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>