Please support our Database Design advertiser: Programming Forums
Views: 7805 | Replies: 5
 |
•
•
Join Date: Mar 2004
Location: Fort Kent, ME
Posts: 2
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
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
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
Location: London, Ontario, Canada
Posts: 54
Reputation:
Rep Power: 6
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
•
•
Join Date: Feb 2002
Location: Long Island, NY
Posts: 1,134
Reputation:
Rep Power: 12
Solved Threads: 4
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.
_.:: my websites ::._
blog @ www.samaru.net * engi No Jutsu @ www.narutorp.net * portfolio @ shinylight.com
deviantART: inscissor
blog @ www.samaru.net * engi No Jutsu @ www.narutorp.net * portfolio @ shinylight.com
deviantART: inscissor
•
•
Join Date: Mar 2004
Location: Rancho Santa Margarita, California
Posts: 209
Reputation:
Rep Power: 5
Solved Threads: 11
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.
•
•
Join Date: Mar 2004
Location: Fort Kent, ME
Posts: 2
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
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."
•
•
Join Date: Jun 2004
Posts: 32
Reputation:
Rep Power: 5
Solved Threads: 1
Light Poster
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
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
