I imported this data base from access 97 to access 2000 and it works but when I try to add any thing it gives me the
"Invalid Bracketing of name" error the orignal sql has 7 UNION SELECT statements simalar to the two shown here (shorted for easy reading) and works fine but we will need to add more tables shortly
can any guru help please


SELECT U.[Machine Name], U.[Part Number], U.Description, U.Programs
FROM [SELECT
"Mori" as [Machine Name],
[Part Number],
[Description],
[Programs]
FROM Mori
UNION SELECT
'LE' as [Machine Name],
[Part Number],
[Description],
[Programs]
FROM LE
]. AS U;