Converting a MS access database to Visual basic??

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?
SalviaAsked:
Who is Participating?
 
Arthur_WoodConnect With a Mentor Commented:
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.

AW
0
 
mlmccCommented:
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.

http://www.gfminc.com/accessto.htm

mlmcc
0
 
SunBowCommented:
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.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
CleanupPingCommented:
Salvia:
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 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0
 
mlmccCommented:
3-way split

mlmcc
0
 
SalviaAuthor Commented:
sorry guys I dont know how or even see an option to split points
0
 
Arthur_WoodCommented:
to SunBow,

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

AW
0
All Courses

From novice to tech pro — start learning today.