I did upsized my access 2003 project to sql2005 express edition so I can use access only as a back end for the users in the network. Everything went fine except one thing, as usual.

I do have an access form which has as data source a query :
SELECT Company_Trucks.Truck_ID, Company_Trucks.Plate_NO, Company_Trucks.Plate_NO, Company_Trucks.Company_ID

FROM State INNER JOIN Company_Trucks ON State.State_ID = Company_Trucks.State_ID

WHERE Company_Trucks.Company_ID = [forms]![Daily_Clearences_input_data]![Company_ID]

ORDER BY Company_Trucks.Plate_NO;

After the upsize the all WHERE clause is going away so my form does not have a proper data source.

Is there any way to fix this and to point my where clause to a field in my access form?

Also when I tried to modify manually the query in the access end I got an error message as "This version of Microsoft Office Access doesn't support design changes with the version of Microsoft SQL your Access project is connected to. See the Microsoft Office update web site for the latest information and downloads... Your design changes will not be saved."

Any work around about this issue to?