[lkennemur]

Hello, I have a db in Access that needs to be put on the web. I am uncertain of what course I should take because I have no web programming experience. I have not made the decision about working with Access or completely rebuilding the database using different software that would be more compatible with web apps. I need as many suggestions as possible about both options.

Thanks,
Lesley

[mab]

Originally Posted by lkennemur

Hello, I have a db in Access that needs to be put on the web. I am uncertain of what course I should take because I have no web programming experience. I have not made the decision about working with Access or completely rebuilding the database using different software that would be more compatible with web apps. I need as many suggestions as possible about both options.

Thanks,
Lesley

These are only some suggested paths you can take -

Everything you see in a bowser on the Internet is based on HTML. Scripting languages are able to create dynamic web pages (especially those that get data from a database) and output HTML to a browser. The most popular script languages at this time are PHP, ASP, and ASP.NET (those of you using other languages, feel free to mention them.)

For the Internet, you basically have a database and an application written in a script language that gets data into/out of the database and presents it on a web site for user interaction. With the standalone Microsoft Access product, the database and the user interface are all rolled up together.

Since Access is a Microsoft product, Microsoft would recommend that you use ASP (older language) or ASP.NET (latest language) and do this on a Windows based server (both of these languages are Microsoft products.)

PHP is a more widely used, widely available, widely supported, and easier to learn and understand language (and yes I have used ASP.) If PHP is on a windows server, you can probably access your Access database. I have not done this, but I am sure it is possible to export the data in your Access database and import it into a mysql database. Mysql database servers are again more widely used, widely available, widely supported, and cost less since the mysql server software is free to use.

Since PHP has a larger base of users and contributors, you are more likely to find a template or database application tool available for it, that will help you create your user interface for you database, at a lower cost, than what you will find for ASP/ASP.NET.

[lkennemur]

I did get a suggestion to look at Openoffice.org and convert my Access db and go to hotscripts.com for scripts. Would you mind taking a look at these sites in your spare time and let me know what you think?

Thanks,
Lesley

[mab]

Originally Posted by lkennemur

I did get a suggestion to look at Openoffice.org and convert my Access db and go to hotscripts.com for scripts. Would you mind taking a look at these sites in your spare time and let me know what you think?

Thanks,
Lesley

I can only comment on hotscripts.com, as this forum is related to that popular script site.

For PHP scripts and tools that might help you with your database application, you should probably look in their Database Tools catagory as a starting place - http://www.hotscripts.com/PHP/Script...ols/index.html