 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / July 2006database website
Is there an easy way to use frontpage to convert MS access database. I have mid size database that I would like to convert to a webbased. Is there an easy way of doing it? (a third party software, using frontpage or dreamweaver etc.) I would appriciate any comments. Best regards. No, you cannot convert an Access database. If you store the Access database tables on the server where your FrontPage website runs, you can use the Database Interaction Wizard to do simple (I emphasize _simple_) database access from FrontPage. Access has a feature called Data Access Pages, but its limitations are such that it is rarely used other than on intranets, and, according to the Access developer's blogs, is being "deprecated" in the next version, Access 2007. I wouldn't recommend it, unless you are sure you can live with the limitations and are able to keep Access 2003 for any maintenance that it might need. Larry Linson Microsoft Access MVP > Is there an easy way to use frontpage to convert MS access database. I > have mid size database that I would like to convert to a webbased. Is > there an easy way of doing it? (a third party software, using > frontpage or dreamweaver etc.) I would appriciate any comments. > > Best regards. Larry; thank you for the speedy reply. So what would be your suggestion in terms of converting the DB to web. Best regards Zeki > No, you cannot convert an Access database. If you store the Access database > tables on the server where your FrontPage website runs, you can use the [quoted text clipped - 16 lines] > > > > Best regards. > So what would be your suggestion > in terms of converting the DB to web. That would depend on your needs and on the environment available to you at the web server. If the web server is running Windows, you can use ActiveX Server Pages (.asp) or the newer ASP.NET to create a web application that uses either your Access tables, or uses those tables re-created in MS SQL Server and populated from your Access tables. Both of those have some learning curve, and converting a vital business application isn't likely the easiest way to start. If your web server is running Linux or Unix, then you'll likely have to convert your data to whatever database it provides and use a different language to create the application. I don't know enough about those environments to make useful suggestions. And, as I said, if the web server runs Windows and the data handling requirements are simple, Front Page and the Database Interaction Wizard would be the easiest approach to implement, but the least flexible. Larry Linson Microsoft Access MVP |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.