database website "iridium" <zcgokce[ at ]gmail.com> 21.07.2006 01:17:58 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.

Re: database website "Larry Linson" <bouncer[ at ]localhost.not> 21.07.2006 03:07:28 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 "iridium" <zcgokce[ at ]gmail.com> wrote in message news:1153444678.134178.45740[ at ]m73g2000cwd.googlegroups.com... [Quoted Text] > 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. >

Re: database website "iridium" <zcgokce[ at ]gmail.com> 21.07.2006 12:01:14 Larry; thank you for the speedy reply. So what would be your suggestion in terms of converting the DB to web. Best regards Zeki Larry Linson wrote: [Quoted Text] > 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 > > "iridium" <zcgokce[ at ]gmail.com> wrote in message > news:1153444678.134178.45740[ at ]m73g2000cwd.googlegroups.com... > > 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. > >

Re: database website "Larry Linson" <bouncer[ at ]localhost.not> 22.07.2006 00:25:15 "iridium" wrote > 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