You have three choices really:
SqLite
SqlCE
Access
They are all similar, but Access has been a PITA since I first met it and it still isn't perfect. Works though.
SQLCE is a bit limited compared to the other two, but has a very small footprint.
I'd probably go with SqLite.