I have just finished building a dynamic driven site using ASP and Access on dreamweaver and have attempted moving it onto an intranet server and converting the access database to an sql database.

The site begins with a password protected index page that links to a customer overview page listing clients. Each client hyperlinks to a product detail page with options to add a new product. Each product then hyperlinks to a detailed product page with the option of editing and deleting the products.

I have still retained functionality on some pages, but not all, and before some pages load I am recieving error messages. Some examples are:

Line 9
Char 1
Error: Syntax error
Code: 0
URL:

Line 47
Char 1
Error: Object required
Code: 0
URL:

I have looked at permissions on the sql databases and tables and cant see anything obvious.

Help greatly appreciated

Cubanallstar.