RSS Forums RSS
Please support our MS Access and FileMaker Pro advertiser: Programming Forums
Views: 36051 | Replies: 27
Join Date: Jun 2005
Location: Texas
Posts: 120
Reputation: jwshepherd is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 5
jwshepherd's Avatar
jwshepherd jwshepherd is offline Offline
Junior Poster

Re: MS Access vs. MySQL

  #20  
Jun 16th, 2005
Originally Posted by dina
Hey there everyone!

I'm just about to start a database assignment for uni but don't know whether to use MS Access or MySQL. I am an adequate use of both but does anyone know the advantages and disadvantages of them???

Thanks


I usually do my initial layout, design and refine my database with MS Access, I can carry it with me on my laptop and pocket pc.

I have a few programs that use access as a backend for over 200 users ( not concurrent ) and as a backend db for a few small sites I host.

Depending on the number of records, the number of concurrent users, the length this will be in use, and the OS it will run on, would be your determining factors.

access will be ok with about 20 concurrent users
access will only manage a db of about 2gb
access would be great for small short term projects
access will only work in a windows environment

anything parameters greater than those should be considered reason enough to switch to Mysql
Reply With Quote  

Only community members can participate in forum threads. You must register or log in to contribute.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes
Forums | Blogs | Tutorials | Code Snippets | Whitepapers | RSS Feeds | Advertising
All times are GMT -4. The time now is 11:53 am.
Newsletter Archive - Sitemap - Privacy Statement - Acceptable Use Policy - Contact Us
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC