Access to .Net

I have an access program that I would like to convert to sql server and a browser based front end.  Does any one know if there are tools available to assist in this.  I have already converted the program to SQL server.  Now I need to find a way to convert all of the input screens.

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

if you have all the Access tables in SQL server now, you can create a .net project. from the Server Explorer panel in Visual Studio, select your SQL server and expand it to see all your tables. you can drag a table and drop it into a windows form and Visual Studio will automatically create a from that contains all the fields  of the table and the code you need to add/edit/save records to the table!
Jeffrey CoachmanMIS LiasonCommented:

You can, (as Dr-Hussain posted) create "new" forms in .net from SQL data.

However, ...It is not that easy to simply "Covert" your Access forms to "Web" forms.
Access forms contain fuctionality that is only viable in the Desktop environment.
And as such, it will not directly translate into the corresponding web functionality.
(or any other programming platform)

There are programs that "claim" to do this conversion, but from what I hear about most of them, is that they are not worth the trouble.
A lot can get lost or scrambled in the translation.

It may not be what you want to heare, but if you want to make "sure" your shiny new app is top-notch, your best bet will be to re-create the forms and the functionality from scratch in the new programming environment.



Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
I'll second Jeff's comments.
PS. No points here please....
xiaoxia2Author Commented:
Thank you all for verifying what I suspected.  
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.