Converting Existing Access front end to VB Project

[MooseMan]

We have inherited another Access database from a defunct department which needs revamping. It is split into a FE and a BE. It is written exclusively in Access using the built in controls and wizards and VBA code.

Is it possible to convert the front end into a VB project and then using connection properties to link to the tables? As a result we would do all our development in the VB6 environment which for us would be preferable.

Any advice would be appreciated.

Thanks Mooseman

 

[UncleJack]

I don't believe it's possible. Access is a mish-mash of various languages and won't translate to any single language very well. I suspect the native code of Access is C based, but it obviously interfaces with SQL and VBA so conversion would be impractically difficult.

Uncle Jack

 

[Databaseguy]

VBA is a sub set of VB, and many of the objects, properties and methods will be familiar to you if you're a VB Guy.

VB has the added advantage of Control Arrays, which Access does not support.

However, you will have to create all of the forms and reports from scratch. You can use the ADODB Data Access Object, Data Grid, Etc. to get at the data in the original Access back end.

Plus side is it will be robust, and distributable. Minus is it will be a lot of work.

My two cents.



Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy

 

[JoaoTL]

Hi, in Access 2000 Dev 1.5 you have a Add-In "Multi-Code Export" that export your project to VB. I never used it but it works. Best Regards

---
JoaoTL
NOSPAM_mail@jtl.co.pt

http://www.jtl.co.pt

http://www.jtl.co.pt/Access