troubleshooting Question

Cannot Add New Record When Using A Left Join in Access

Avatar of Nickon17
Nickon17Flag for United States of America asked on
Microsoft AccessSQL
5 Comments2 Solutions402 ViewsLast Modified:
I am trying to add a a new record into my SQL 2000 table (using Access as the front end).  I have a left join between the route and stops table.  When I try and use the query tool in access, it does not allow be to add a new stop.  That is all I want to do it add a new stop to a route.  Please let me know what I am doing wrong.  I am passing the query using ADO (in case anyone needs know).  I DO NOT want to use split forms, this is all done through code.
SELECT Route.RouteID, Route.Route, STOPS.StopID, STOPS.STOP
FROM Route LEFT JOIN STOPS ON Route.Route = STOPS.ROUTE
WHERE (((Route.Route)="ABC"));

Open in new window

ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros