 |  |  |  |  |  |  |  |
Access Web Database?
Please support our Database Design advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
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
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
-- Trésha Marie Betancourt --
"Old enough to know better,
still too young to care."
•
•
Join Date: Mar 2004
Posts: 54
Reputation: 
Solved Threads: 5
Junior Poster in Training
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.
=====================
If you have a question for the monthly column Computer Geek email Jeff at: geek@bizwriter.biz
Jeff Johnston is a Computer Technician for The London Transit Commission in London Ontario. He is also a writer and editor in chief of The Business of Writing
Ask The Computer Geek can be read at Families On Line Magazine
=====================
Jeff Johnston
Freelance Writer & Computer Geek Extraodinare
Editor-in-Chief
The Business of Writing
Writer
Families On-Line Magazine
NewsFactor
If you have a question for the monthly column Computer Geek email Jeff at: geek@bizwriter.biz
Jeff Johnston is a Computer Technician for The London Transit Commission in London Ontario. He is also a writer and editor in chief of The Business of Writing
Ask The Computer Geek can be read at Families On Line Magazine
=====================
Jeff Johnston
Freelance Writer & Computer Geek Extraodinare
Editor-in-Chief
The Business of Writing
Writer
Families On-Line Magazine
NewsFactor
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.
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.
Check out my blog at http://www.shinylight.com for more stuff about web dev.
•
•
Join Date: Mar 2004
Posts: 209
Reputation:
Solved Threads: 12
Posting Whiz in Training
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.
PARANOIA:
A healthy understanding of the way the universe works.
A healthy understanding of the way the universe works.
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.
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.
-- Trésha Marie Betancourt --
"Old enough to know better,
still too young to care."
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
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
|
Similar Threads
- Web database design (PHP)
- MS Access with a web front ent (MS Access and FileMaker Pro)
- Want help making program access a web page automatic. (C)
- Internet Explorer 6 will not access web (Web Browsers)
Other Threads in the Database Design Forum
- Previous Thread: Export SQL
- Next Thread: Text data type troubles in T-SQL
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Database Design Posts
- Today's Posts
- Unanswered Threads