[AccessD] Access Reserved words

jm.hwsn jm.hwsn at gmail.com
Tue Mar 8 15:23:53 CST 2011


Are you talking about the entire suite or just the Total Access Analyzer?
JIm

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl Collins
Sent: Tuesday, March 08, 2011 3:02 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access Reserved words


____________________________________________________________________________
___________

Note: This e-mail is subject to the disclaimer contained at the bottom of
this message.
____________________________________________________________________________
___________




try "be interested to know more FROM a real user."


__________________________________
From: accessd-bounces at databaseadvisors.com
[accessd-bounces at databaseadvisors.com] On Behalf Of Darryl Collins
[Darryl.Collins at iag.com.au]
Sent: Wednesday, 9 March 2011 7:51 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access Reserved words



Jim,

I would like to know more about your thoughts on this product.  It looks
rather useful, but i note it is also rather pricey.  Now that maybe ok as it
might still be great value for money given what it can do.  Or it may not
be...

be interested to know more for a real user.

cheers
darryl.

________________________________________
From: accessd-bounces at databaseadvisors.com
[accessd-bounces at databaseadvisors.com] On Behalf Of jm.hwsn
[jm.hwsn at gmail.com]
Sent: Wednesday, 9 March 2011 6:28 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Access Reserved words

My customer of the Access 2007 project I'm working on wanted some
functionality that is not native to Access.

For example, they wanted full Rich Text Formatting for several fields.
These fields are used as feedback papers for the users.

They purchased the FMS Total Access Ultimate Suite to be used with this
project.

One of the components is the Total Access Analyzer.

I received the suite after I essentially finished the majority of the work.

I ran the analyzer and it told me that I have 954 objects documented.  It
has 85 tables, 451 queries, 125 forms, 74 reports, 1 macro and 25 modules.
It also informed me that there was a table that wasn't being used and a
field in two queries that didn't belong to any table.  It also told me it
found 244 errors, 3042 suggestions on improving it and 830 performance
issues.

I haven't worked through most of them yet, but many are small things such as
"transaction log" for a query is turned on and should be turned off.

One item identified is:  a column "conflicts with future SQL Server reserved
word."

I did some research and found out the reserved words it talks about have
been on the list since at least 2000 and is still on list for SQL Server
2010.

Another item was:  a column "conflicts with Jet reserved word."  In the
description it says it's a "minor issue."

I am aware of the problems of using reserved words.

BUT. I used "language" and "comp" as field names.  I should have known
better, but I also used "order" and "default."

I have had NO issues with these reserved words - yet.

My question is:  Should I spend the time to change the field names?

If I don't change them, what kind of problems will it create?



Thanks,
Jim





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

The information transmitted in this message and its attachments (if any) is
intended only for the person or entity to which it is addressed.
The message may contain confidential and/or privileged material. Any review,
retransmission, dissemination or other use of, or taking of any action in
reliance upon this information, by persons or entities other than the
intended recipient is prohibited.

If you have received this in error, please contact the sender and delete
this e-mail and associated material from any computer.

The intended recipient of this e-mail may only use, reproduce, disclose or
distribute the information contained in this e-mail and any attached files,
with the permission of the sender.

This message has been scanned for viruses.
____________________________________________________________________________
___________

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

The information transmitted in this message and its attachments (if any) is
intended only for the person or entity to which it is addressed.
The message may contain confidential and/or privileged material. Any review,
retransmission, dissemination or other use of, or taking of any action in
reliance upon this information, by persons or entities other than the
intended recipient is prohibited.

If you have received this in error, please contact the sender and delete
this e-mail and associated material from any computer.

The intended recipient of this e-mail may only use, reproduce, disclose or
distribute the information contained in this e-mail and any attached files,
with the permission of the sender.

This message has been scanned for viruses.
____________________________________________________________________________
___________

--
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