Access Web Database?
 

I'm a student in an E-Commerce program and I agreed to do a capstone project in my web design class as a blog site, where I can register users (with an access database) and have them update entries whenever they feel up to it...

I'm a competant web developer, but I have only a basic knowledge of making plain access databases and no clue how to go about setting up a database that you can have someone add to online.

Can anyone start me off in the right direction with this?

Thanks :confused:

Re: Access Web Database?
 

I would first off recommend against using access for this type of application. You would be much better off using MySQL, it is much better suited for your needs.

Re: Access Web Database?
 

You being a web developer, I'm assuming you know how to program. Web developers develop web software. What language would you like to use? PHP? ASP? ColdFusion? Java? Perl?

I also recommend you go with MySQL server. Access is just a file, and craps out once you got over 8 people connecting to it at the same time. With MySQL, because it's a server, it handles all the user sessions appropriately.

Re: Access Web Database?
 

I can vouch for Access terrible reliability when in heavy use. It works great for small applications, but something like this heavy calls for a full fledged database server. I can't tell you how much pain me and my boss have been through with Access at our clients.

Re: Access Web Database?
 

Honestly, the only reason why I've been bothering with an access database is because my professor doesn't provide a SQL server for us to run off of (which really bites). I've found SQL script is easy to find if you need code and not very difficult to understand. On the other hand, my brother and I own a site together where I have access to a SQL server (gotta check with my prof, but I'm sure I could bounce it from there). Although, really I'm not expected to have any more than 5 people using the site as an example.

As for what language, I perfer PHP. I only ever partially learned perl and I kicking myself for not learning the others yet, but I'm still a freshman-- I'll figure it out.

Re: Access Web Database?
 

the issue here is not the databse.. although access is not good for larger sites..

you need to run some basic SQL queries thought your code

like

INSERT INTO table_name
VALUES (value1, value2,....)


read this:
http://www.w3schools.com/sql/sql_insert.asp

also, if you need to learn how to create database connections, get WROX ASP.NET FOR BEGINNERS

jack
www.ansariltd.com