I just discovered why my program (DW) keeps crashing whenever I try to make SQL changes - apparently, the word 'found' is a reserved word. I have a lost and found pet website! I have to use the word 'found'! Any suggestions??
I just discovered why my program (DW) keeps crashing whenever I try to make SQL changes - apparently, the word 'found' is a reserved word. I have a lost and found pet website! I have to use the word 'found'! Any suggestions??
Allen Browne has a list of reserved words
http://allenbrowne.com/AppIssueBadWord.html
Here is a list of Reserved Words from Microsoft. I don't find "Found" amongst that list.
http://office.microsoft.com/en-us/ac...010030643.aspx
Alan
"Found" is a JET reserved word. You can try bracketing it:
[Found]
or simply use things like PetLost and PetFound as field names. Using "Found" in captions and such for the user would not cause any issues.
FOUND is a Reserved Word for SQL Server. For a complete list see...
http://msdn.microsoft.com/en-us/libr...v=sql.80).aspx
To avoid such issues I use a Naming Convention...
My Naming Conventions
I originally found the word on this list: http://support.microsoft.com/kb/321266. It is also found on many other lists out there. The word is not being used in the Access column titles, only the data. The problem occurs in Dreamweaver when trying to use the word in a SQL statement.
I can see that because SQL Statement in talking to the Server would get *confused*.