[AccessD] Article on upgrading

I would lend this to your proposed article.

1. Find any occurrences of "Select" plus anything, either in RecordSources
or DataSources. Revise said code to refer to a named query.
2. Make sure that all date-fields are not null, giving them instead a
default value of Date() at worst, but supplying some value at least.
3. Make sure that all FKs hold true; no orphans whatever, else the whole
migration will fail.
4. Strictly a matter of opinion, but MO is that 3NF is insufficient for
serious dbs; 4- and 5-NF are mandatory.

A.

On Thu, Jul 28, 2011 at 12:54 PM, Susan Harkins <ssharkins at gmail.com> wrote:

> 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.
>
>