features to avoid when starting fresh

  • Thread starter Thread starter Kathy R.
  • Start date Start date
K

Kathy R.

I'm finally updating an old membership database that I started years ago
in Access 95. I've decided to start from scratch because there are a
number of things that I didn't design correctly and I now have Access 2007.


I know that most of you recommend that Name AutoCorrect be turned off,
and that lookup fields in tables shouldn't be used, but I seem to recall
that there were two or three other "features" that should be avoided as
well.

Since I am drawing a blank as to what these features are called, I can't
search for information regarding them in these forums and I apologize
for asking something that I am sure has been discussed multiple times
before.

A quick, short (hopefully!) list would be very much appreciated.

Kathy
 
I'm finally updating an old membership database that I started years ago
in Access 95. I've decided to start from scratch because there are a
number of things that I didn't design correctly and I now have Access 2007.


I know that most of you recommend that Name AutoCorrect be turned off,
and that lookup fields in tables shouldn't be used, but I seem to recall
that there were two or three other "features" that should be avoided as
well.

Since I am drawing a blank as to what these features are called, I can't
search for information regarding them in these forums and I apologize
for asking something that I am sure has been discussed multiple times
before.

A quick, short (hopefully!) list would be very much appreciated.

Kathy
Click to expand...

I'd avoid using Subdatasheets (or actually, I'd set the Subdatasheet
properties of all tables to [None] instead of Microsoft's default [Auto]).
Also (at least in 2003) there's a box on Tools... Options... Tables for "Auto
index on create/import" which puts (usually uneeded and excessive) indexes on
fieldnames based on the *field name*; I blank this box out and assign my own
indexes based on need, not on whether they happen to end in the letters "num".
 
Uncheck 'Compile on Deman'

Get into the VBA editor.
Tools --> Options ---> General Tab
Uncheck, 'Compile on Demand'
 
I remember trying to make a checklist for myself several years ago.. I'll
look for it.

But here's one off the top of my head: Access assigns a default value of
zero to number fields in tables - this can cause problems, so remember to
remove that default when creating number fields.
 
Chuckle. Ok. Thanks Gina! How 'bout I just leave quietly now before I
embarrass myself any more? ;)
 
Oh, my head isn't hanging! Over the years I've looked foolish often enough -
I'm not the least bit worried about it at all. :)

What I'm *really* worried about is Jeff finding out that I made that mistake
about Access 2007! If he does, I'll be in for a stern lecture about getting
with the program and making some progress in learning Access 2007 inside and
out! ;)

Cheers!
 
Thank you everyone! I've been lurking on these boards for years and the
help that you all give is awesome. I really appreciate it.

Kathy
 
Back
Top