• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 208
  • Last Modified:

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.

2 Solutions
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.


Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
I'll second Jeff's comments.
PS. No points here please....
xiaoxia2Author Commented:
Thank you all for verifying what I suspected.  
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now