homepage Welcome to WebmasterWorld Guest from 54.166.122.86
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Hardware and OS Related Technologies / Website Technology Issues
Forum Library, Charter, Moderators: phranque

Website Technology Issues Forum

    
Database Question
Is MS Access any good for my project?
TimmyMagic

10+ Year Member



 
Msg#: 2372 posted 1:05 pm on Jul 5, 2003 (gmt 0)

Hi folks,

I need some advice and where better than this excellent forum.

I am in the very early stages of a new project. This is a dating site in a niche market. I have been looking into the basic infrastructure of the site and have come across someone who will sell me the basic site which I can then modify.

The system runs on an ASP server that can interpret MS Access dbases. So my question is, is MS Access a good database for this purpose? or does it have any faults such as being too lightweight or such like?

I have little knowledge of how databases so any input would be appreciated.

Regards,
Tim

 

Nick_W

WebmasterWorld Senior Member nick_w us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 2372 posted 1:15 pm on Jul 5, 2003 (gmt 0)

Hi,

I don't know the specifics but like most of M$ products in the server-side field it certainly has a bad reputation. I'll let the real experts give you the specifics but I'd swing a wide arc around that thing if I were you...

Nick

SEO practioner

10+ Year Member



 
Msg#: 2372 posted 2:36 pm on Jul 5, 2003 (gmt 0)

Timmy- Nick is 100% right.

Personally, when I design a database-driven site, I almost always use MySQL and have it run over PHP or JSP.

Unless a client specifically requests a MS product such as Access, I go the MySQL route. I even go so far as sometimes discouraging them to use Access.

Access is also very limited in the amount of data it can hold. If your site grows fast, as it should, you may run out of space with access.

Good luck

TimmyMagic

10+ Year Member



 
Msg#: 2372 posted 3:07 pm on Jul 5, 2003 (gmt 0)

Thanks for your comments.

Although i don't know too much about it, I did think that MS Access may not hold enough info. I'm a bit gutted though, because the site I wish to model mine on looks good. I don't have any experience of MySQL so I will have to start learning.

Cheers,

Tim

TimmyMagic

10+ Year Member



 
Msg#: 2372 posted 3:26 pm on Jul 5, 2003 (gmt 0)

Upon relaying my concerns about MS Access, the guy whose site I am wanting to model mine on replied:

"The dbase is efficient to about 2-300,000 members, whereafter a conversion to MySQL would be a good idea. This conversion is very simple - a programmer
could write a script for it in a matter of hours. I am not aware of any MySQL dbases for this kind of site."

Is he correct?

Cheers,

Tim

killroy

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 2372 posted 3:34 pm on Jul 5, 2003 (gmt 0)

Well, I took long enough to do the jump to MySQL (not from MS but my own engine), and it was well worth it.

One I overcame my own fear of the onknown, it turned out to be much simpler then my previous solution. If you spend some time to get into ti you will find that not only is MySQL technically suitable, but also quite easy to mantain, run and program for.

SN

txbakers

WebmasterWorld Senior Member txbakers us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 2372 posted 3:23 am on Jul 6, 2003 (gmt 0)

Absolutely avoid Access for any web database. Use mySql. It's free and easy to get up and running on any platform server.

Access is a good desktop database, not a server, and can't handle web traffic.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Hardware and OS Related Technologies / Website Technology Issues
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved