Hi,
I am getting the following error on the list page, and the Add page will not save (I am presuming it is because of the same error, but am not sure)
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '[TypeLoan] = Car Loan - New Car'.
/qryNewConsultantLoan_list.asp, line 1427
If I go in and add talking marks, to either side of Car Loan - New Car, then it works, but I have to do this for all look ups - which I can cope with in the list page, but have no idea how to fix this in the Add page.
I am using the new version of ASPRunner and have tried to recreate these pages numerous times.
I have been building the site in stages (as my clients require numerous changes and there are quite a few design changes) i.e. this latest page is a new query - maybe I am not transferring all the correct files over, or maybe I have to update some files that are already on the webstie. Prior to the new version - I just added the list, add etc pages and the 3 include files for that page, and all worked, is there something else I need to do also, with this new version?
I am positive this is the problem because if I upload the pages I have just built - by themselves then all works well. I realise it is not a problem with AspRunner, but if you could give me a clue as to what other files I need to change/add, it would be much appreciated.
Otherwise, I may need just to start from scrtach.
Thanks
Julie
