Access based stand-alone apps?

[Mermogoat]

I have seen stand-alone applications that use MS Access databases to store the data. Can this be exported from Access to an executable, stand-alone format? Or would I need to create it in Visual Basic or Visual C++ and then connect it to the Access database? I would think you could even possible export the database, forms and all, to Visual Basic. Is this possible?

What I am doing is making a program for my Dad's company. I'm starting out with just the forms and stuff in Access, and once that is finished I want to turn it into a stand-alone app.

 

[boblarson]

You can create a VB front end and use it with an Access backend. I'm sure you can do it with other programming languages too, I just happen to use VB.

 

[Mermogoat]

Could you give me a little bit of info on how to do that, or point me to somewhere on the net where it explains it.

Could I Import my forms from Access to VB to save some time?

 

[boblarson]

1. No, you can't import your forms.

2. You can connect via ADO, or with the Data Control.

 

[Mermogoat]

Ok...So I would create my forms in VB...would I have to create the access DB w/ just the tables in it and then link it to the forms, or what? I'm kinda unsure since an Access *.mdb file has all the info(querys, tables, forms, etc) and not just the tables/data.