Unable to create table using Access 97

[George]

Hi,
When trying to create a table from a linked table on a SQL server, I get the
following errors:
"ODBC--call failed." and
"[Microsoft][ODBC SQL Server Driver]Invalid character value for cast
specification (#0)"

The table on the server has over 36,000 records and 72 fields. I'm trying to
make an archive of this table as we use it for reference on specific time
periods. Are there any limitation in MS Access 97 with respect to table size?
Any help is appreciated.

 

[John W. Vinson]

Hi,
When trying to create a table from a linked table on a SQL server, I get the
following errors:
"ODBC--call failed." and
"[Microsoft][ODBC SQL Server Driver]Invalid character value for cast
specification (#0)"

The table on the server has over 36,000 records and 72 fields. I'm trying to
make an archive of this table as we use it for reference on specific time
periods. Are there any limitation in MS Access 97 with respect to table size?
Any help is appreciated.

It's not complaining about table size. It's complaining about an "Invalid
character value for cast specification (#0)". It sounds like there may be an
error in the passthrough query that you're running.

John W. Vinson [MVP]

 

[George]

Hi John,
Can you tell me what might be the cause(s) of this error? What is that error
message really telling me? What is odd is I can view the linked table, but if
I try to go to the end of the table I get the same error messages. I don't
have much experience with creating tables on SQL server, but I understand
some basic programming concepts.

Thanks for taking the time to help!
George Cook

Hi,
When trying to create a table from a linked table on a SQL server, I get the
following errors:
"ODBC--call failed." and
"[Microsoft][ODBC SQL Server Driver]Invalid character value for cast
specification (#0)"

The table on the server has over 36,000 records and 72 fields. I'm trying to
make an archive of this table as we use it for reference on specific time
periods. Are there any limitation in MS Access 97 with respect to table size?
Any help is appreciated.

It's not complaining about table size. It's complaining about an "Invalid
character value for cast specification (#0)". It sounds like there may be an
error in the passthrough query that you're running.

John W. Vinson [MVP]

 

[George]

Hi John,
Disregard my follow up question. My administrator didn't refresh all of the
views, despite assuring me they had done everything possible.....All is fine
now.

Thanks!
George Cook

Hi,
When trying to create a table from a linked table on a SQL server, I get the
following errors:
"ODBC--call failed." and
"[Microsoft][ODBC SQL Server Driver]Invalid character value for cast
specification (#0)"

The table on the server has over 36,000 records and 72 fields. I'm trying to
make an archive of this table as we use it for reference on specific time
periods. Are there any limitation in MS Access 97 with respect to table size?
Any help is appreciated.

It's not complaining about table size. It's complaining about an "Invalid
character value for cast specification (#0)". It sounds like there may be an
error in the passthrough query that you're running.

John W. Vinson [MVP]