I'm working on an application that retrieves data from a remote MS SQL database and need to store some of the information locally for offline retrieval of information later on. Would a local Access database be the best way to handle this?

Also, where can I find information on creating the database in code?

Thanks in advance for your help.