[AccessD] MDBs vs SQL Server

I hear ya on the Oracle subject.....

Setup SQL Server on my home machine a few months ago, and took to it like a
duck to water.  Everything just seemed, well, obvious, to how it worked.

Started working with Oracle when I first started working here (4 years ago).
Getting data in and out is fine, but it is running on a Unix box, and is
just an absolute complete nightmare to do anything with it!

Drew

-----Original Message-----
From: chizotz at charter.net [mailto:chizotz at charter.net]
Sent: Monday, December 29, 2003 1:19 PM
To: Access Developers discussion and problem solving
Subject: Re: RE: [AccessD] MDBs vs SQL Server


Mark me down as between a 2 and a 3, I suppose.

I use SQL Server almost daily, and love it. I also use .mdb backends almost
daily and love 'em. I choose the best system based on the data requirements
of the project, how it will be deployed, etc. I have nothing against either
system, they are tools and nothing more, and as tools they each have
strengths and weaknesses; I just look at it as part of my job to determine
what tool is best for the job at hand.

I also, to my great displeasure, use Oracle almost daily and despise it (but
you didn't ask about Oracle) :)

So what's this Reflex thangie, sounds cool lol

Ron


> 
> -----Original Message-----
> From: John W. Colby [mailto:jcolby at colbyconsulting.com]
> Sent: Monday, December 22, 2003 7:23 PM
> To: AccessD
> Subject: [AccessD] MDBs vs SQL Server
> 
> 
> I'd like to conduct a non-scientific poll to discover what you folks use.
> Please pick one of the numbers and respond to the list.
> 
> 1) I use SQL Server for all my data.  I wouldn't touch an MDB BE with a 10
> foot pole.
> 2) I use SQL Server mostly, but will touch an MDB BE with a 10 foot pole,
as
> long as I don't have to be responsible for the mess.
> 3) I have used SQL Server in at least one actual client system but my
bread
> and butter is made with MDB BEs.
> 4) I am fascinated with the possibilities of SQL server, have looked at
it,
> perhaps installed it at my office, but just don't have the call for it
from
> my clients.
> 5) What's this here SQL Server thangie?  All my database BEs are done with
> MDBs.
> 6) I prefer to do my data stores in Excel spreadsheets, but if I must an
MDB
> is at least within my grasp.  SQL Server is for them big boys n they won't
> talk to me.  I would still be using Borland's Reflex if I could get a copy
-
> now THERE's a REAL MAN'S database!!!
> 
> Just pick a number and put it in the first line of your response.
> 
> As for me, I am a 4.  I have SQL Server installed in my office, moved my
> billing db to it in order to have a real live in use system using it, and
> have regretted it ever since.  In fact I yanked the data back out into an
> MDB last week after having to rebuild my system twice and then ending up
> with torn pages in my SQL Server database.
> 
> John W. Colby
> www.ColbyConsulting.com
> 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com