[AccessD] Help with string

Spell, Cynthia G. cspell at jhuccp.org
Wed Mar 21 10:58:07 CDT 2007


VERY useful, at least for me.  Thank you!

Cindy

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Bartow
Sent: Wednesday, March 21, 2007 11:12 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [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

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



More information about the AccessD mailing list