|
Home > Archive > MS SQL Server > November 2006 > Link Tables
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| stoney 2006-11-09, 7:13 pm |
| Hi,
Trying to link tables from Access 2000 to SQL 2000. Am successfully linking
tables as long as there are no spaces in the table name.
tableA from access to TableA to SQL link successfully.
table B from access to TableB or table B get odbc -- call failed
help
stoney
| |
|
| stoney wrote:
> Hi,
>
> Trying to link tables from Access 2000 to SQL 2000. Am successfully linking
> tables as long as there are no spaces in the table name.
>
> tableA from access to TableA to SQL link successfully.
> table B from access to TableB or table B get odbc -- call failed
>
> help
>
> stoney
Hi Stoney
You don't say how you link the tables, but try to put [] around the name
- e.g. [Table B].
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator
|
|
|
|
|