I am trying to build a web interface for my database. To be honest I know nothing about asp, so I found this package and thought I would give it a try. I followed the wizard and was impressed to see that I had a login page, which works, and that I could use the menu to open the table I wanted and sure enough there is all my data, it looks alright and is searchable!
However I do have a major problem that I would really appreciate some help with.
Within each table there are links to see the child tables - I don't seem to be able to get any of these to work. For example I have a table "Company details" and another related table "Colaboration"
When I click the collaberation link I get the error message below. I can see that the cause of the error is in the where part of the SQL statment and that Company ID = 1 needs to be in [] but how do I make these changes? I can't seem to see how to change this. Any help would be much appreciated
error number: -2147217900
Error description: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Company ID=1'.
url: /test/Colaboration_list.asp
SQL query: select [Collaberation ID], [Company ID], [Type of Collaberation], [Other Details] From [Colaboration] where Company ID = 1
