Number of characters in a table name

[inungh]

I have 2 tables which has 2 long table name.
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]

I have many tables with names longer than 10 characters. I've not seen this
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]

I have many tables with names longer than 10 characters.  I've not seenthis
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.









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

It would help us diagnose the error you're getting if you would post the SQL
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.

I have many tables with names longer than 10 characters. I've not seen
this
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.









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

 

[Tony Toews]

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]

Thanks for asking the question. I decided to create a blog posting on
this topic.
http://msmvps.com/blogs/access/arch...ip-between-two-tables-with-lengthy-names.aspx

Tony

 

[inungh]

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

Tony

Thanks millions for helping,

 

[Tony Toews]

Thanks millions for helping,

You're quite welcome. This was an interesting questikn.

Tony

 

[David W. Fenton]

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?

 

[Tony Toews]

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]

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?

 

[Tony Toews]

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