access/visual basic

[tim duranko]

Can someone give me a basic understanding of the
difficulties I might run into using both visual basic and
microsoft access? What I am trying to do is create a
input screen that stores or links all data to a microsoft
access database. Does anybody have any experience in this
area? Please respond. Thank you!

 

[Albert D. Kallal]

I don't think there is any real difficulties.

However, you have not really stated why you want to use VB in place of
ms-access to do this?

 

[John Vinson]

Can someone give me a basic understanding of the
difficulties I might run into using both visual basic and
microsoft access? What I am trying to do is create a
input screen that stores or links all data to a microsoft
access database. Does anybody have any experience in this
area? Please respond. Thank you!

Both Visual Basic and Access have Forms which can do what you
describe. In my experience, Access forms (being designed specifically
to work with databases) are much easier to create and implement; I'm
not sure why you would want to go to the considerable extra effort to
construct VB forms for this purpose, though there are cases where you
might want to do so.

If you do decide to use VB, you have your choice of opening the .mdb
file using either ADO or DAO; each method has its plusses and minuses.
Examine both to see which fits your needs better.

 

[Larry Linson]

You'll find a presentation I did comparing VB and Access as database
front-ends at http://appdevissues.tripod.com/downloads.htm. It should give
an overview of topics I thought worth discussing.

Larry Linson
Microsoft Access MVP