We help IT Professionals succeed at work.

convert access 2007 to... VB.net or C# etc etc

bede123
bede123 used Ask the Experts™
on
hi all,

just a quick question... if i wanted to convert an access 2007 db along with all the forms and functions etc to something like VB.net or C#... is this possible and of so are there any third party tools out there that would help?

thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Aaron TomoskyDirector of Solutions Consulting

Commented:
Imo The first step would be to move the backend to SQL. Then you could write a new front end in c#.
Michael VasilevskySolutions Architect

Commented:
Yeah there's no converting per se. You'd have to re-write all the forms, reports, etc. in the new architecture of your choice.

Author

Commented:
hmm, the back end is the easy bit to be honest. i dont fancy attempting to rebuild all the front end stuff.

Author

Commented:
when i said back end i mean the DB.

i wasn kinda hoping someone had invested a magic tool to doo the rest! :-)
Aaron TomoskyDirector of Solutions Consulting

Commented:
There is a magic tool to move from mdb to adp (access front SQL back). Its the wizard in access.
Commented:
just found this.

it might help with the conversion of the forms. what do you guys think?

http://msdn.microsoft.com/en-us/library/aa140069(office.10).aspx

Commented:
and this:

http://members.shaw.ca/irie/iriehometab.html

i think this is the one. if i'm understanding it correctly all i have to do is upsize the db to SQL then use this tool to convert the objects into vb.net.

pretty cool eh!

zac
Michael VasilevskySolutions Architect

Commented:
hmm might be a good starting point. I imagine you'll still need to do some customization to get the coverted objects optimized for a web interface.

Let us know how it goes!

MV

Author

Commented:
found solutution myself on this occassion.

Author

Commented:
thanks.

found solution myself on this occassion
Aaron TomoskyDirector of Solutions Consulting

Commented:
Can you at least take the time to share the solution?

Author

Commented:
please see my two posts above

Author

Commented:
also i didnt want to offend anyone by not awarding points for helpfulness but the last time i did that i got jumped on by everyone telling me that, that's not the way the forum works and i should only award points once the question has actually been answered.