I'm a VB6 programmer VERY new to ASP.net. I have a VB6 game which is basically a VB6 front-end to an Access db. My task is to convert my app so that it can be played on the Web. I've been advised that Access won't scale well to the Web - that it's concurrency issues will prevent more than a few users at a time from using the app.
My questions are these: Am I better off converting the Access db to MySQL or to MsSQL Express? What kind of conversion issues am I facing? i.e - Access is naturally available inside the VB6 IDE. Once I established a connection string to Access, I simply wrote Access SQL, put it in a VB6 module and called the module when needed.
I need to know how big a task I face getting the game online. Any ideas would REALLY help. Thank you.
My questions are these: Am I better off converting the Access db to MySQL or to MsSQL Express? What kind of conversion issues am I facing? i.e - Access is naturally available inside the VB6 IDE. Once I established a connection string to Access, I simply wrote Access SQL, put it in a VB6 module and called the module when needed.
I need to know how big a task I face getting the game online. Any ideas would REALLY help. Thank you.