If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Microsoft Access > Is it bad to have Client_ID in a database?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Aug 2012
Posts: 70
Is it bad to have Client_ID in a database?

I am making a database for school work and just sent it my teacher to check, I was given feedback saying that Client_ID is usually rejected by access, is this true and why?
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Mar 2009
Location: Dorset
Posts: 117
I've not seen that before. Maybe it's an issue with another language/database. Below is a list of reserved words and Client_ID isn't in it:

List of reserved words in Access 2002 and in later versions of Access
__________________
Regards
JD

Bespoke Access Database Design and Development Services
Software Matters - Simple Solutions That Work!
Reply With Quote
  #3 (permalink)  
Old
Moderator
 
Join Date: Jun 2005
Location: Richmond, Virginia USA
Posts: 2,407
Being retired, I work this and four or five other Access forums for 6-8 hours a day, and have done so for seven years, now, and have never seen any reports of such! Also, not exactly sure what the phrase "usually rejected by access" means! To be honest, the teaching of Access in many schools gets shoved off on someone who wouldn't really qualify as a 'power user,' in Access, much less someone who should be teaching it!

Linq ;0)>
__________________
Hope this helps!

The Devil's in the Details!!

All posts/responses based on Access 2003/2007
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: Aug 2012
Posts: 70
ah right, ok, I'll keep it then.

Thanks
Reply With Quote
  #5 (permalink)  
Old
Moderator
 
Join Date: Jun 2005
Location: Richmond, Virginia USA
Posts: 2,407
I have no idea whatsoever what your instructor was referring to. As has been stated it is not a Reserved Word, in Access, and there is nothing wrong with the naming convention used, i.e using an Underline character to connect Client and ID. Using a Space between the two parts would be inappropriate, and can lead to problems, but not Client_ID.

Linq ;0)>
__________________
Hope this helps!

The Devil's in the Details!!

All posts/responses based on Access 2003/2007
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On