Wednesday, March 28, 2012

Link Tables

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
stoneystoney 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 Administratorsql

No comments:

Post a Comment