Invalid Field Name

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

stephanie.harrell@stateauto.com - 24 Oct 2005 15:37 GMT

I have an Access project that I created from an existing Access
database. SQL is 2000, Access is both 2000 and 2003.

The existing Access tables had field names like [IDF DATA(1)],
[IDF DATA (2)], [IDF DATA (3)]. Those names are ok in SQL as long as
you use the brackets around them. The user wanted to add a few more,
so in design view, she copied the line and inserted it below. She
changed the name to [IDF DATA(4)] - using the brackets - and saved.
She received the error message

The name 'IDF DATA (4)' is invalid because it is empty, contains
invalid characters, or contains more than 128 characters.

I don't understand why the old names are ok, but adding a new one gives
the error. I can go in to SQL Server Enterprise manager and copy the
column.

Any thoughts anyone? I'd really like from my user to be able to do
this without my involvement and without giving her Enterprise Manager.

Reply to this Message

Bill Edwards - 26 Oct 2005 04:29 GMT

From Access Help:

"In Microsoft Access, names can be up to 64 characters long and can include
any combination of letters, numbers, spaces, and special characters except a
period (.), an exclamation point (!), an accent grave (`), and brackets
([ ])."

>I have an Access project that I created from an existing Access
> database. SQL is 2000, Access is both 2000 and 2003.
[quoted text clipped - 15 lines]
> Any thoughts anyone? I'd really like from my user to be able to do
> this without my involvement and without giving her Enterprise Manager.

Reply to this Message

Robert Morley - 26 Oct 2005 21:23 GMT

This is somewhat of a guess, but try adding the field without the []'s...I
think SQL Server will realize it needs them and add them on its own.

Rob

Reply to this Message

Sylvain Lafontaine - 26 Oct 2005 23:09 GMT

The SQL-Server: yes but the table design tools in ADP: no (with or without
[] or "). This is one of the numerous known (and old) bugs of ADP.

Signature

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

> This is somewhat of a guess, but try adding the field without the []'s...I
> think SQL Server will realize it needs them and add them on its own.
[quoted text clipped - 20 lines]
>> Any thoughts anyone? I'd really like from my user to be able to do
>> this without my involvement and without giving her Enterprise Manager.

Reply to this Message

Robert Morley - 27 Oct 2005 21:28 GMT

Ah, thanks for the info, Sylvain. Guess I'd simply never come across this
problem before.

Thanks again,
Rob

> The SQL-Server: yes but the table design tools in ADP: no (with or without
> [] or "). This is one of the numerous known (and old) bugs of ADP.

Reply to this Message