[AccessD] Access and SQL Server

Darryl Collins Darryl.Collins at iag.com.au
Sun Feb 27 15:13:53 CST 2011


_______________________________________________________________________________________

Note: This e-mail is subject to the disclaimer contained at the bottom of this message.
_______________________________________________________________________________________


Tony,

Why I like a SQL server BE.

1: Performance.  It is faster and much more stable, especially if set up correctly and over a WAN / LAN.
2: Security of access and the actual data itself.
3: Audit: It is dead easy to set up triggers to show who changed what, when and from where.
4: Backup and restore is better
 cheers
darryl



________________________________________
From: accessd-bounces at databaseadvisors.com [accessd-bounces at databaseadvisors.com] On Behalf Of Tony Septav [iggy at nanaimo.ark.com]
Sent: Monday, 28 February 2011 12:43 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Access and SQL Server

Hey All
Well I have spent a couple of weeks now fooling around with ACCESS and
SQL Server. Using fairly complex pass through queries, ADO connections
with stored procedures and Views, I have still to buy Susan's book to
answer some of my under lying questions. Other than being prepared for a
client's request to use SQL Server, I keep asking myself when would I
need to use this.  Only a few of my applications I have out there are
dealing with records greater than a million. Because the apps are user
specific I don't usually have more than 10 users on a network.  I don't
think any of my clients (including the big companies) know what SQL
Server is. In fact I have produced only one app for a client that linked
into an Oracle database (that is the flavour in my area not SQL).  Yes I
know SQL Server has hundreds of nifty little features that ACCESS
doesn't, many activities use a SQL Server link (Web Pages), so it begs
the question "Should I be learning how to develop  a SQL Server app from
the bottom up?"

What I am finding is that an ACCESS/SQL Server app becomes very code
intensive (forms, queries, etc) much more so than just using ACCESS.

My question to those of you proficient in using ACCESS and SQL Server,
how exactly are you applying it?
Are you producing major apps dealing with millions of records?
Are you producing major apps dealing with hundreds of users?
How do you go about distributing changes to an ACCESS/SQL Server app?




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

The information transmitted in this message and its attachments (if any) is intended 
only for the person or entity to which it is addressed.
The message may contain confidential and/or privileged material. Any review, 
retransmission, dissemination or other use of, or taking of any action in reliance 
upon this information, by persons or entities other than the intended recipient is 
prohibited.

If you have received this in error, please contact the sender and delete this e-mail 
and associated material from any computer.

The intended recipient of this e-mail may only use, reproduce, disclose or distribute 
the information contained in this e-mail and any attached files, with the permission 
of the sender.

This message has been scanned for viruses.
_______________________________________________________________________________________




More information about the AccessD mailing list