Syntax Error in Access 2003 but works fine in Beta 07

  • Thread starter Thread starter SteveC
  • Start date Start date
S

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
 
"doesn't work" doesn't provide much information about your results. Can you
provide more information? Do other queries in 03 work?
 
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.
Duane Hookom said:
"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

SteveC said:
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
Click to expand...
Click to expand...
 
LOL. When I redid the field, the Source Code reverted, so it opens with an
error in Access 2003 again.
SteveC said:
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.
Duane Hookom said:
"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

SteveC said:
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
Click to expand...
Click to expand...
Click to expand...
 
You might want to set the database options to turn off the AutoName correct
options.
--
Duane Hookom
MS Access MVP

SteveC said:
LOL. When I redid the field, the Source Code reverted, so it opens with
an error in Access 2003 again.
SteveC said:
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.
Duane Hookom said:
"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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top