Syntax Error in Access 2003 but works fine in Beta 07

[SteveC]

This Source query works in Beta07 but doesn't work on Access 03. Anyone see
what's wrong with it? It was generated automatically by '07. Thanks.

SELECT Computers.*, Locations.Position, Locations.[Location Description],
Locations.StaffID FROM Locations RIGHT JOIN Computers ON
Locations.LocationID=Computers.LocationID;

Thanks

 

[Duane Hookom]

"doesn't work" doesn't provide much information about your results. Can you
provide more information? Do other queries in 03 work?

 

[SteveC]

Yes, the others work. When I changed source back to just Computers (Table),
it worked. Of course, then a merged field didn't work. I redid the field
and now everything seems to work just fine. I am learning by doing, so
forgive me for the dearth of information.

"doesn't work" doesn't provide much information about your results. Can
you provide more information? Do other queries in 03 work?

--
Duane Hookom
MS Access MVP

This Source query works in Beta07 but doesn't work on Access 03. Anyone
see what's wrong with it? It was generated automatically by '07.
Thanks.

SELECT Computers.*, Locations.Position, Locations.[Location Description],
Locations.StaffID FROM Locations RIGHT JOIN Computers ON
Locations.LocationID=Computers.LocationID;

Thanks

 

[SteveC]

LOL. When I redid the field, the Source Code reverted, so it opens with an
error in Access 2003 again.

Yes, the others work. When I changed source back to just Computers
(Table), it worked. Of course, then a merged field didn't work. I redid
the field and now everything seems to work just fine. I am learning by
doing, so forgive me for the dearth of information.

"doesn't work" doesn't provide much information about your results. Can
you provide more information? Do other queries in 03 work?

--
Duane Hookom
MS Access MVP

This Source query works in Beta07 but doesn't work on Access 03. Anyone
see what's wrong with it? It was generated automatically by '07.
Thanks.

SELECT Computers.*, Locations.Position, Locations.[Location
Description], Locations.StaffID FROM Locations RIGHT JOIN Computers ON
Locations.LocationID=Computers.LocationID;

Thanks

 

[Duane Hookom]

You might want to set the database options to turn off the AutoName correct
options.
--
Duane Hookom
MS Access MVP

LOL. When I redid the field, the Source Code reverted, so it opens with
an error in Access 2003 again.

Yes, the others work. When I changed source back to just Computers
(Table), it worked. Of course, then a merged field didn't work. I redid
the field and now everything seems to work just fine. I am learning by
doing, so forgive me for the dearth of information.

"doesn't work" doesn't provide much information about your results. Can
you provide more information? Do other queries in 03 work?

--
Duane Hookom
MS Access MVP

This Source query works in Beta07 but doesn't work on Access 03.
Anyone see what's wrong with it? It was generated automatically by
'07. Thanks.

SELECT Computers.*, Locations.Position, Locations.[Location
Description], Locations.StaffID FROM Locations RIGHT JOIN Computers ON
Locations.LocationID=Computers.LocationID;

Thanks