Go Back   Access World Forums > Microsoft Access Reference > Sample Databases

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-28-2018, 02:03 AM   #1
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 10,464
Thanks: 40
Thanked 3,381 Times in 3,276 Posts
CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice
Consequences - Reserved Words

This thread is intended to provide real life examples of the potential consequences of using reserved words in field and table names.

A link to reserved words can be found here
https://support.office.com/en-gb/art...9-f855bdd9c5a2

and here is a link to an example where using reserved words (even with the advised use of square brackets) was creating an unexpected error. Changing the names resolved the issue

https://www.access-programmers.co.uk...23#post1593223

Please feel free to add your own links

__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button

Last edited by CJ_London; 09-28-2018 at 02:37 AM. Reason: update reserved word link (thanks Colin)
CJ_London is offline   Reply With Quote
The Following 2 Users Say Thank You to CJ_London For This Useful Post:
NauticalGent (10-06-2018), Uncle Gizmo (09-28-2018)
Old 10-04-2018, 09:35 AM   #2
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 10,464
Thanks: 40
Thanked 3,381 Times in 3,276 Posts
CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice
Re: Consequences - Reserved Words

here is another one

https://www.access-programmers.co.uk...73#post1594173
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Reserved Words Case Sensitive? PaulJR Theory and practice of database design 6 06-19-2008 08:03 AM
Reserved Words in Access RoyVidar Access FAQs 0 06-12-2007 10:56 AM
Reserved Words Mark-BES General 3 05-12-2005 09:43 AM
Consequences of not declaring variables yhgtbfk General 8 10-17-2004 02:36 PM
Getting around SQL Reserved Words... Mitch_____W Queries 1 11-16-2001 07:11 AM




All times are GMT -8. The time now is 04:55 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World