473,385 Members | 2,005 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

access vs sql

Hi, I'm new here but I'm lookin for some help.
I need to create a DB that can put on the web. The DB will have about 500 entries. within each db entry I'll be adding multiple comments and archiving them for each entry.
I would like to have this on the web, searchable and easily updated.
Can any of you tell me which program would be better suited for this?
Thank you,
Aug 16 '07 #1
6 904
pbmods
5,821 Expert 4TB
Heya, 10ashsd. Welcome to TSDN!

What software will your server be running (e.g.., Apache vs. IIS)?
Do you have any previous database server experience?
What sort of traffic do you anticipate?
Aug 16 '07 #2
I don't really know. I'm novice in this area. My ultimate goal is to have something on a server hosted from home which means not that many simultaneous users. less than 100.

I'm certainly open to suggestions.

even if you or someone on this forum could suggest some direction for learning I am certainly open to reading up on this stuff.
Thank you,
Aug 16 '07 #3
jhardman
3,406 Expert 2GB
I don't really know. I'm novice in this area. My ultimate goal is to have something on a server hosted from home which means not that many simultaneous users. less than 100.

I'm certainly open to suggestions.

even if you or someone on this forum could suggest some direction for learning I am certainly open to reading up on this stuff.
Thank you,
I think a lot of people start out with access and then if they find that this isn't big enough they move up to msSQL, they conversion is fairly straight-forward. This is what I did, and I only ever had small conversion problems.

However, some of the best out there currently are actually free: MySQL works very well for big and small applications and is free open source (although not especially user-friendly and might be harder for novices to handle).

Jared
Aug 17 '07 #4
pbmods
5,821 Expert 4TB
(although not especially user-friendly and might be harder for novices to handle).
I don't know what you're talking about.
Aug 17 '07 #5
jhardman
3,406 Expert 2GB
I don't know what you're talking about.
My impression of MySQL has been that it is very powerful, but "bare-bones" as far as user interface and appearance. I think this makes it daunting to novices. Maybe this isn't the case if you get it as part of a package (like WAMP). What is your experience?

Jared
Aug 17 '07 #6
pbmods
5,821 Expert 4TB
Heya, Jared.

To be honest, I don't have enough experience with any other database server software to be able to make an objective evaluation.

But I've always liked MySQL, so I recommend it.

What features do you feel are missing from MySQL?
Aug 18 '07 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

63
by: Jerome | last post by:
Hi, I'm a bit confused ... when would I rather write an database application using MS Access and Visual Basic and when (and why) would I rather write it using Visual Studio .Net? Is it as easy...
13
by: bill | last post by:
I am trying to convince a client that dotNet is preferable to an Access project (ADP/ADE). This client currently has a large, pure Access MDB solution with 30+ users, which needs to be upgraded....
1
by: Dave | last post by:
Hello NG, Regarding access-declarations and member using-declarations as used to change the access level of an inherited base member... Two things need to be considered when determining an...
13
by: Simon Bailey | last post by:
I am a newcomer to databases and am not sure which DBMS to use. I have a very simplified knowledge of databases overall. I would very much appreciate a (simplifed) message explaining the advantages...
0
by: Frederick Noronha \(FN\) | last post by:
---------- Forwarded message ---------- Solutions to Everyday User Interface and Programming Problems O'Reilly Releases "Access Cookbook, Second Edition" Sebastopol, CA--Neither reference book...
20
by: Olav.NET | last post by:
I am a .NET/C++ developer who is supposed to do some work with Access. I do not know much about it except for the DB part. Questions: *1* I am looking for INTENSIVE books to get quickly up to...
64
by: John | last post by:
Hi What future does access have after the release of vs 2005/sql 2005? MS doesn't seem to have done anything major with access lately and presumably hoping that everyone migrates to vs/sql. ...
1
by: com | last post by:
Extreme Web Reports 2005 - Soft30.com The wizard scans the specified MS Access database and records information such as report names, parameters and subqueries. ......
17
by: Mell via AccessMonster.com | last post by:
Is there a way to find out where an application was created from? i.e. - work or home i.e. - if application sits on a (work) server/network, the IT people know the application is sitting...
37
by: jasmith | last post by:
How will Access fair in a year? Two years? .... The new version of Access seems to service non programmers as a wizard interface to quickly create databases via a fancy wizard. Furthermore, why...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.