The priority issue is the dsn less database connection. I have attempted to use the following in the connection wizard-
MM_dsnname_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Server.Mappath("../db/products.mdb") & ";" & _
"User Id=admin;" & _
Above is exactly how I copied into the connection wizard box in one line. Do I need to alter this to suit my set up and include the actual path to the database, I have attempted this and it still does not work.