hi all,

I am planning to create a simple database driven application and need some advice on how to proceed. I would also like to include some kind of barcode system so that users can swipe a card into a reader and have their record updated on the database. Is this possible? I think I have a handle on most of that aspect, though.

Can I use AMS to manipulate an Access database, or should I use SQL. Will SQL need to be installed on the client machine?

I have seen there is a plugin - sql lite or something? I have looked on the website for information on this, such as how it works and how much it costs, but couldn't find anything definite.

I would also like to know how I can generate key codes for the software, in a similar way to MS key generation.

Your help is appreciated.