[AccessD] Article on upgrading

Gustav Brock gustav at cactus.dk
Thu Jul 28 13:29:26 CDT 2011


Hi Susan

Nice to see back doing tech writing! 

We've never had a client asking why, they all follow my advice(!)
So our reasons to suggest and upgrade:

1. Extreme reliability is requested. I have yet to see an SQL Server break down.
2. Remote access (across a WAN) is needed.
3. Easy, daily, and reliable backup is requested even when clients are on-line.
4. Database size can be expected to outgrow Access' capability.
5. Controlled and secure user access is requested.

Note the non-tech level of these parameters.

/gustav
 

>>> ssharkins at gmail.com 28-07-2011 18:54:58 >>>
I'll be writing about upgrading to SQL Server and I'd like to include as many of you in it as possible -- you'll get credit and a link -- it's a nice thing to show the boss and clients. 

The angle is -- questions you should ask when deciding whether to upgrade an Access database to SQL Server (Express is Okay too) -- specific to the decision-making process. Anything you think someone considering the move should evaluate before doing so -- but I'll be writing it from a "questions you should ask" perspective. 

It'll be interesting reading for the list too I think, so if nobody objects -- I see no reason to ask for these responses off list. 

Thanks!
Susan H. 





More information about the AccessD mailing list