We help IT Professionals succeed at work.
Get Started

Cannot Add New Record When Using A Left Join in Access

Nickon17
Nickon17 asked
on
400 Views
Last Modified: 2010-04-21
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

Comment
Watch Question
Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009
Commented:
This problem has been solved!
Unlock 2 Answers and 5 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE