Re: oracle vs. ms access

"Greg Forestieri" <gforestieri9_at_yahoo.com> wrote in message news:6a8cdd95.0409270523.6bf49647_at_posting.google.com...
| "Terence Hill" <phayaok_at_hotmail.com> wrote in message
news:<An74d.303219$vG5.11513_at_news.chello.at>...
| > This sounds like a joke, but my company really thinks about a supply
| > software that is based on a access db. Please give me comments against
| > access in relation to oracle.
| >
| > Thanks for help
| >
| > Walter
|
| I know you are not joking, I've seen lunacy like this before.
|
| My heart goes out to you.
|
| "We're taking a trip to the moon - which way do we go? Apollo rocket
| or one of them things the Boy Scouts play with. Uh idunno Vern, them
| Boy Scout rockets sure is cheap."
|
| You build a "prototype" in Access and they end up making it a
| production system. They save "big bucks". That's another thing that
| I've seen happen.
|
| If they want more than 1 or 2 users to be able to use the system at a
| time they need to avoid Access. You can argue MS SQL Server, you can
| argue SYBASE, you can't argue Access. It's just not practical for
| anything beyond a "personal computing application". Remind them that
| it comes bundled with Office, which is a "personal computing
| platform".
|
| Good luck

question... is it access gui + access database, or is it access gui + either SQL Server or MS's mini-SQL Server (forget the official name)?

is the backend is not access, that changes the equation

but for any software purchase evaluation, just make sure all functional and performance criteria are documented, including transaction volume and concurrent users. then you've got something specific to measure with.

if you've got a small company with 3-4 individuals using the software, no IT department, a local service provider, etc., etc. -- basically a mom & pop company with a sw product tailored to a niche, MS Access may not necessarily be evil (better than shoeboxes full of receipts). but if you've got an IT department and reasonable budgets, then you need something that does not rely on the MS Access back-end

you're probably not planning a moonshot, but you've got to have your target clearly defined to know if the tool is going to get you there.

++ mcs Received on Mon Sep 27 2004 - 08:42:57 CDT