I have an Access database, that is in connection with sql server.On my computer with access2007 i have no problems with viewing tables and stuff.But on other computers with access2003 it gives an error when i use this query:INSERT INTO [tbl_sap-staffel] ( ItemCode, CardCode, [Amount-0], [Price-0], [Amount-1], [Price-1], [Amount-2], [Price-2] )SELECT [qry_sap-spp-0].ItemCode, [qry_sap-spp-0].CardCode, [qry_sap-spp-0].Amount, [qry_sap-spp-0].Price, [qry_sap-spp-1].Amount, [qry_sap-spp-1].Price, [qry_sap-spp-2].Amount, [qry_sap-spp-2].PriceFROM ([qry_sap-spp-0] LEFT JOIN [qry_sap-spp-1] ON ([qry_sap-spp-0].ItemCode = [qry_sap-spp-1].ItemCode) AND ([qry_sap-spp-0].CardCode = [qry_sap-spp-1].CardCode)) LEFT JOIN [qry_sap-spp-2] ON ([qry_sap-spp-1].ItemCode = [qry_sap-spp-2].ItemCode) AND ([qry_sap-spp-1].CardCode = [qry_sap-spp-2].CardCode);
It says:quote:
ODBC call failed[Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'MS1' does not match with a table name or alias name used in the query.The column prefix 'MS2' does not match with a table name or alias name used in the query.
The column prefix 'MS1' does not match with a ...
Posted - 2007-08-29 : 08:35:35
