ms access and sqlite

[DevAccess]

Hello

I am using sqlite as backend and ms access front end application.


there are two questions I have with this development.

I would like to store the attachment in sqlite from ms access ( like native functionality of ms access ) how to make this possible ?

as in Sqlite we dont have attachment as datatype.


second question is that.

In ms access front end i am saving date field as dd/mm/yyyy but it store the data into sqlite table as mm/dd/yyyy, please assist. why this is happening.

 

[Minty]

Q2 - Dates are really stored as yyyy-mm-dd in SQL but displayed based on something else. The default is almost certainly mm/dd/yyyy as it is the default for MS SQL Server as well.

Q1. - The only way would be to use a BLOB (Large Binary object) and a complete shed load of code - vaguely useful link here http://www.ammara.com/access_image_faq/read_write_blob.html

And if they are large your database will get very big very quickly. Personally I wouldn't bother, as you won't get the functionality of clickable icons, drag and drop will be difficult to implement etc etc.

Store the file path and store the document on a network share.

 

[DevAccess]

Q2 - Dates are really stored as yyyy-mm-dd in SQL but displayed based on something else. The default is almost certainly mm/dd/yyyy as it is the default for MS SQL Server as well.

Q1. - The only way would be to use a BLOB (Large Binary object) and a complete shed load of code - vaguely useful link here http://www.ammara.com/access_image_faq/read_write_blob.html

And if they are large your database will get very big very quickly. Personally I wouldn't bother, as you won't get the functionality of clickable icons, drag and drop will be difficult to implement etc etc.

Store the file path and store the document on a network share.

My issues is that I would want to show them this table as just for view purpose and they want to see the dates in table of sqlite in dd/mm/yyyy format. ( I will be showing sqlite table as odbc link table in ms access )

 

[Minty]

Simply query the table and format the displayed values in the query. Two seconds work, and much less dangerous than letting the users at the table directly.