Number of characters in a table name
inungh
I got table name to long when I create table relationship with 2
tables.
It seems that MS Access create a query or view using 2 tables names
combined and can not over maximum characters allowed.
If this is the case we have to try to use table name not more than 10
characters, since it will be easier to over limitation if MS Access
use table name to create link.
Please let me know if I am wrong,
Your information is great appreciated,
Jeff Boyce
error message.
If you'll post the SQL statement of the query in which you are getting this
error message, maybe folks here can see something else that might be causing
the error.
Regards
Jeff Boyce
Microsoft Office/Access MVP
--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.
Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.
You can thank the FTC of the USA for making this disclaimer
possible/necessary.
"inungh" <inu...@gmail.com> wrote in message
news:91039044-30ed-4aeb...@j4g2000yqh.googlegroups.com...
inungh
>
> - Show quoted text -
Thanks for the message,
My tables have long table name which more than 35 characters.
I got error message that table name too long when I create table
relationship and it shows tables names combined together. It seems MS
Access to create another name using 2 table names together,
If this is the case then we need have table name shorter to avoid this
happening.
Can someone tell me if I am wrong that MS Access does create a table
name using 2 link tables?
Your help is great appreciated,
Jeff Boyce
statement that your query uses.
Regards
Jeff Boyce
Microsoft Office/Access MVP
--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.
Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.
You can thank the FTC of the USA for making this disclaimer
possible/necessary.
"inungh" <inu...@gmail.com> wrote in message
news:a8bc6e22-71e6-42eb...@r27g2000yqb.googlegroups.com...
Tony Toews
wrote:
>My tables have long table name which more than 35 characters.
>I got error message that table name too long when I create table
>relationship and it shows tables names combined together. It seems MS
>Access to create another name using 2 table names together,
Oh yes, I've seen that message when creating relationships in the
past.. I just reprod your situation and got the same message which has
to do with creating an index name which concatenate the two table
names.
The message is "<combined table names> is not a valid name. Make sure
that it does not include invalide characters and that it is not too
long."
Needless to say the message is not clear as to what is going on,.
When I want to directly create an index I got the following message:
The index name is invalid.
The index name may be too long (over 64 characters) or contain
invalid characters.
A workaround would be to temporarily rename a table so the combined
table names are less than the 64 characters. Create the relationship
and the rename the table back.
Tony
Tony Toews
wrote:
Thanks for asking the question. I decided to create a blog posting on
this topic.
http://msmvps.com/blogs/access/archive/2010/06/22/misleading-error-message-when-creating-relationship-between-two-tables-with-lengthy-names.aspx
Tony
inungh
> On Tue, 22 Jun 2010 10:19:17 -0700 (PDT), inungh <inu...@gmail.com>
> wrote:
>
> Thanks for asking the question. I decided to create a blog posting on
>
> Tony
Thanks millions for helping,
Tony Toews
wrote:
>> Thanks for asking the question. �I decided to create a blog posting on
>> this topic.http://msmvps.com/blogs/access/archive/2010/06/22/misleading-error-me...
>>
You're quite welcome. This was an interesting questikn.
Tony
David W. Fenton
news:0fp226lv7mqrmbn9l...@4ax.com:
> A workaround would be to temporarily rename a table so the
> combined table names are less than the 64 characters. Create the
> relationship and the rename the table back.
Is it possible to create the relationship/index in code and name the
index explicitly?
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Tony Toews
<XXXu...@dfenton.com.invalid> wrote:
>> A workaround would be to temporarily rename a table so the
>> combined table names are less than the 64 characters. Create the
>> relationship and the rename the table back.
>
>Is it possible to create the relationship/index in code and name the
>index explicitly?
No because this particular index is being created as part of thje
Create Relationships process. And these indexes are created even if
such an index already exsts.
Tony
David W. Fenton
You mean that creating the relationship in code creates the hidden
index? Even if an index that does exactly the same thing already
exists?
Tony Toews
<XXXu...@dfenton.com.invalid> wrote:
>>>> A workaround would be to temporarily rename a table so the
>>>> combined table names are less than the 64 characters. Create
>>>> the relationship and the rename the table back.
>>>
>>>Is it possible to create the relationship/index in code and name
>>>the index explicitly?
>>
>> No because this particular index is being created as part of thje
>> Create Relationships process. And these indexes are created even
>> if such an index already exsts.
>
>You mean that creating the relationship in code creates the hidden
>index? Even if an index that does exactly the same thing already
>exists?
Yes. Keeping mind that a duplicate index does not take any
additional space.
Tony