Thank for the reply. I'll start by saying I have Googled the legs of this subject but everyone seems to want to set this up in Flex, not Flash. Then again, I clearly haven't Googled enough.
RE: Targeting AIR, thanks will bear this in mind.
With SQL lite, is the database created on a fly?
I don't suppose you know of any books that go through this process?
Books tend to outdate fast, here is a very basic tutorial, how you use SQL inside Flash.
If you have in mind to actually administrate your sqlLite DB, you shoud consider to get an Admin tool like LITA
Beware if you use any code examples, most of them won`t compile off-the-shelf with the current AIR-Version (3.5)
So be prepared to do some debugging.
That's fair enough, if it was easy everyone would be doing it I suppose.