[AccessD] Help with string

This may be useful:

Using names for tables, table fields, queries, and query columns that
conflict with reserved words can cause problems later in the design life of
an application and/or a database. Some of the conflicts can arise when
referencing an object or try to connect to a datasource. Other conflicts can
arise if you try to upsize your database to SQL Server.

Jet reserved words:
http://support.microsoft.com/default.aspx?scid=kb;en-us;321266
	  
SQL Server reserved words:
http://msdn2.microsoft.com/en-us/library/aa238507(SQL.80).aspx
	  
Future SQL Server reserved words:
http://msdn2.microsoft.com/en-us/library/aa238507(SQL.80).aspx
	  
ODBC reserved words:
http://msdn2.microsoft.com/en-us/library/aa238507(SQL.80).aspx
	  
Non-standard characters: (',*") 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Tuesday, March 20, 2007 10:44 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Help with string

Month is probably a reserved word (I didn't look it up). It might work, but
eventually, it's probably going to cause you a problem. I'd rename that one.


Susan H. 

Hi,
Can someone help with the following string?  FA is text, Funding is text,
and Month is numeric.


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com