access to standalone app with more stable database

Question

Hi,

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.

Answer 1

• 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

Answer 2

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.