Spaces in Table names?

[Zack Barresse]

Hi there,

New to Access. Wondering what the take is on having spaces in Table names?
Or any other names for that matter, i.e. Forms or Reports. Is there a
general accepted practice? Additional benefits? I'm just starting my first
*real* database and I'd like to not start out on the wrong foot here.

Thanks for your time.

 

[Ken Snell \(MVP\)]

Although you can use spaces in table names and fields names and query names,
it's not recommended. Such names always must be surrounded by [ ] characters
in queries and code. Preferred method is to put words together and
capitalize the first letter of each word; or use an underscore in place of a
space:

FirstName
DateInvoiceCreated
Date_Created
Audit_Total

etc.

 

[tina]

see the following link for some very basic tips (including one regarding
naming standards/conventions) that are aimed specifically at helping newbies
start out on the right track.

http://home.att.net/~california.db/tips.html

hth

 

[Rick Brandt]

Hi there,

New to Access. Wondering what the take is on having spaces in Table
names? Or any other names for that matter, i.e. Forms or Reports. Is
there a general accepted practice? Additional benefits? I'm just
starting my first *real* database and I'd like to not start out on
the wrong foot here.

Thanks for your time.

Never never never use spaces, and whenever possible use nothing but the alphabet
and digits (underscores being one exception). That applies to everything,
tables, forms, reports, fields, you name it.