Choosing language when leaving Access 97
I am working at a maintenance company with an ERP and Production system, built in Access97. Yes I know it is VERY old. I have upgraded the database to SQL Server 2008. Still, the programs are Access97. So now it is time for upgrading these aswell.
What seems to be the easiest way is to upgrade to Access2010 or 2012. Does anybody have experience about upgrading Access multiple levels? Is it a lot work? (We have about 100 forms and 130 reports ) From what I understand, queries and other things use to work, but the VBcode needs to be adjusted.
What do you think about the future of Access? Will MS develop it in the future? If this is an issue, I wouldn’t mind programming in another language. (The current forms is unsecure and needs to be fixed as well) If so, should it be Client-Server or Web?
The factory is placed on one location, so Client-Server should be alright I think, and from my experience it is often faster than a web-application. Or do you have other experiences?
If Client-Server, what language should you than suggest? I have worked with a lot of languages but regarding the windows programming languages I feel a bit inexperienced, but I don’t mind learning it for real.
We have windows servers, with MS SQL. There are about 15 users and
I am the only IT-developer so I would be happy to have some advices from you.