Yet another Access to VB question

[ccflyer]

Hi everyone,

I have read through all of the previous posts that I can find, and I understand that it is impossible to convert an access form to an .exe file. Currently I have my database broken down into a front and back end. Is it possible to independently write a visual basic application completely outside of Access and have it communicate with the back end of my database now?

Thanks,
Chris

 

[mhartman]

Hello
You can use Visual Basic 6.0 or .net to communicate with an Access database.

Regards
Mark

 

[Banana]

Yes. I toyed with it myself.

Getting database connected was the easy part. Working with it, however, is much difficult than working within Access environment as you're totally on your own and have to write code from ground up to check for data integrity and the like.

 

[ccflyer]

I am very new to Visual Basic. First, do you guys think it would be worth reading some books and learning about VB? Second, do you think it would be worth trying to duplicate one of my Access forms in VB?

Thanks for your input,
-Chris

 

[workmad3]

Its always worthwhile learning a bit about the language before diving into things. Personally, the only VB book I have ever read was 'Visual Basic 6.0 for Dummies' which had some stuff in it on connecting to a db from vb and so on.

Also, yeah, try and mimic one of your access forms in VB so you get used to what you need to do to get DB connectivity in a VB application

 

[ghudson]

Access makes it all to easy to interact with your data tables. Creating forms and reports within Access is very easy. As noted above, trying to create a form in Visual Basic 6 is a lot of work. Why try to reinvent the wheel? It can be done but you have to decide if it is worth all the extra work. I have both programs but Access is the way to go for me and my projects.