access to standalone app with more stable database

Does anyone have experience of rapidly translating an access application into a standalone windows application? My current thoughts are to create an SQL database and a gui in c# and vb, or adobe flex 3.

As with acces, the GUI would mainly comprise of controls such as radio buttons, combo box (populated from a table), check boxes, text boxes, text areas and data grids. It will also开发者_运维知识库 need the ability to create reports as access does.

Any advice based would be appreciated.

Happy new year.

---

• Use the upsize wizard (tools menu) to port the data to SQL Server
• Carry on using Access as a front end
• Change the schema as needed, hide change behind views for Access
• Write a new GUI in asp.net or WinForms

---

sqlite may be the choice of database. It is simple, a self-contained, embeddable, zero-configuration SQL database engine. you don't need any database server as sqlite is file-based.

I guess vb.net 2008 can be used as it is very easy to generate GUI.