Access 2002 into VB .Net Application

[t_girgin]

Hi All,

I am thinking about the possibility of migrating from Ms Access 2002 to VB.Net for more cost efficient distribution of applications.

I have seen several applications on the Net for converting Access Applications into VB. I wonder if anyone out there tried to convert an Access 2002 application into VB (Preferably .Net). What was the outcome?

I may be pushing my luck too far but... I have an application that I converted to Access 2002 but uses DAO since it was written originally in Access 2.0! Any specific comments on the problems I may encounter with the legacy DAO code during conversion??

Also, as far as I know .Net platform utilizes Crystal Reports for reporting functionality. Which tool(s) do you suggest for reporting with VB .Net? Comparing what came with Visual Studio 6 Professional, I assume reporting would be the weakest point of VB compared to Access.

Thanks in advance,

Taner

 

[samsmithnz]

The legacy code doesn't convert. Officially you're supposed to upgrade the code to ADO, and THEN upgrade the application to VB.NET.

Technically you should be able to convert all of your VBA code, but you'll probably have to cut and paste it into a VB6 project, you'll get lots of conversion errors, and it may be a lot of trouble (you give no indication of how big your application is).

What I did when I recently converted an application from VB6 was convert it to .NET, then start a new project and add the code snippets function by function, leaving out all the VB workaround code the conversion produces.

No nothing about reporting though. Sorry.