Converting a MS access database to  Visual basic??

Posted on 2003-02-24
Medium Priority
Last Modified: 2013-12-04
Yes I designed a application in Microsoft access 2000 I am wanting to convert this application to visual basic that way it is standalone how can I accomplish this or is it even possible to do without having to completely rewritemy application?
Question by:Salvia
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 44

Accepted Solution

Arthur_Wood earned 80 total points
ID: 8010391
you will probably be better off by re-writing the User Interface in VB 6.  The controls used in Access ARE NOT the same controls as used in VB 6, even though they 'look' the same.

Consider the ComboBox control(almost the same applies to the ListBox control):

in Access, .RowSource and .RowSourceType  and NO .AddItem or .ItemData

the Access combobox is populated by setting the RowSourceType ("Value List", "Table/Query" or "Field List") and the RowSource - Care must be taken if you use "Value List", as BOTH the ";" AND the "," serve as field delimiters (the OFFICIAL documantation say the ";" is the delimiter) - Oh Yeah, the Access ComboBox allows MULTIPLE items in the same ROW (can't be done in a VB 6 ComboBox).

There are many other significant differences, enough that ANY attempt to convert Access VBA to VB 6 will probably produce MORE problems than would be the case with a COMPLETE, from scratch, re-write.

There are numerous differences in the nature of the language, as well.  For instance, VB 6 ALLLOWS the use of Control arrays, while they are not possible with Access VBA.

LVL 101

Expert Comment

ID: 8010548
There is a product from Greenwich called AccesstoVB.  we sued it to convert our Access database to VB.  It worked fairly well.  We still spent some time correcting code but the forms themselves came across fairly cleanly.


LVL 24

Expert Comment

ID: 8010660
First I think you are better off if you are storing as an MDB. Then, recognize as above, that VBA is not VB. Any version of VB you find should work out satisfactory, but it is programming, a little more work for you to define fields, etc. As this is Progamming TA I assume that is your desire, a little more work for more control.
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Expert Comment

ID: 9447538
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
Post your closing recommendations!  No comment means you don't care.
LVL 101

Expert Comment

ID: 9447800
3-way split


Author Comment

ID: 9456652
sorry guys I dont know how or even see an option to split points
LVL 44

Expert Comment

ID: 9477185
to SunBow,

check http://www.experts-exchange.com/Programming/Q_20752804.html for points based on your resposnse to this question.


Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
Performance in games development is paramount: every microsecond counts to be able to do everything in less than 33ms (aiming at 16ms). C# foreach statement is one of the worst performance killers, and here I explain why.
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
Suggested Courses

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question