A serious problem with Access !!!

Hello!

my problem I try to migrate my java application of Database SQL server 2000 worms === è Database Access



my request in SQL Server2000 it functions very well:



select c.varcCodeContinent, c.varclibelcontinent, p.nCodePays,

p.varclibelPays, r.nCodeRegion, r.varcLibelRegion

from unintermitting C left join country p one (c.varcCodeContinent = p.varcCodeContinent)

left join area R one (p.nCodePays = r.nCodePays)





but under Access it does not function.

however the two following requests function under Access



1) - select c.varcCodeContinent, c.varclibelcontinent, p.nCodePays, p.varclibelPays

from unintermitting C left join country p one c.varcCodeContinent = p.varcCodeContinent



2) - select r.nCodeRegion, r.varcLibelRegion

from country p left join area R one p.nCodePays = r.nCodePays



is there a solution PLEASE?