[AccessD] MDBs vs SQL Server

About 2.5 here.  The big databases are on SQL and all but very quick and
dirty new databases go there.  I am still maintaining small databases with
mdb backends.

Debbie

-----Original Message-----
From: rusty.hammond at cpiqpc.com [mailto:rusty.hammond at cpiqpc.com] 
Sent: Tuesday, December 23, 2003 8:53 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] MDBs vs SQL Server


2.5 here

We started out on mdb's and still have several apps running on them but we
are moving a lot of stuff over to SQL server.

-----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
- JENKENS & GILCHRIST E-MAIL NOTICE - This transmission may be: (1) subject
to the Attorney-Client Privilege, (2) an attorney work product, or (3)
strictly confidential. If you are not the intended recipient of this
message, you may not disclose, print, copy or disseminate this information.
If you have received this in error, please reply and notify the sender
(only) and delete the message. Unauthorized interception of this e-mail is a
violation of federal criminal law. 
This communication does not reflect an intention by the sender or the
sender's client or principal to conduct a transaction or make any agreement
by electronic means.  Nothing contained in this message or in any attachment
shall satisfy the requirements for a writing, and nothing contained herein
shall constitute a contract or electronic signature under the Electronic
Signatures in Global and National Commerce Act, any version of the Uniform
Electronic Transactions Act or any other statute governing electronic
transactions.