| Author |
 Topic  |
|
|
betheball
Starting Member
USA
41 Posts |
 Posted - 07 February 2003 : 20:19:35
|
| Just a general DB question. I have read many times that you should not put spaces in field names, like date_of_birth not date of birth. Why is that? Second, and more importantly for my purposes, is it a problem to have a space in the name of the db itself? I noticed the db for this forum is snitz_forums_2000.mdb not snitz forums 2000.mdb. What are the problems/consequences of having spaces. We have a large administrative db at work and I am going to create some ASP pages that use much of that data. The name of the db has a space on it and if that will be a problem, I want to make sure i request the name be changed before running into problems. |
- Duane
"So I got that going for me, which is nice." - Carl Spackler |
Edited by - ruirib on 07 February 2003 21:15:23 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 07 February 2003 : 21:21:02
|
Though you can have spaces in objects names in Access (tables, table columns, forms and such) I think that is simply not worth the trouble. Having spaces in the names of the columns, will force you to use the name inside [] whenever referring to the columns in SQL statements. That enough should be a strong reason to avoid it. There are similar problems when using other Access objects names with spaces.
I don't seem to remember any problems with using spaces in the Db file names. Anyway I prefer not to use them. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
betheball
Starting Member
USA
41 Posts |
Posted - 07 February 2003 : 22:35:07
|
| Thanks Ruirib. I have put that into practice as well. Unfortunately I don't have ownership over this particular db and may not be able to persuade the owner to change it. |
- Duane
"So I got that going for me, which is nice." - Carl Spackler |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
VodkaFish
Average Member
USA
654 Posts |
Posted - 08 February 2003 : 14:24:44
|
| May I also recommend not starting table names and fields with numbers, as that could cause you to also have to use [] around them. |
v ø d k â f ï § h |
|
|
| |
Topic |
|
Topic Locked
