razah

I am having problems submitting data in a form with an apostrophe ('). Only when there is an even number of apostrophes in a text field, it can be submitted.Here is the code: $conn=odbc_connect('ITLog','','');if (!$conn){exit("Connection Failed: " . $conn);}$department = $_REQUEST['department'];$contact = $_REQUEST['contact'];$problem = $_REQUEST['problem']; $sql="insert into IT_Log (department, contact, problem) values ('$department','$contact','$problem')" ; $rs=odbc_exec($conn,$sql);if (!$rs){ exit("Error in SQL");}

I am able to connect to an access database on a local hard drive but unable to connect to one on a network drive.Does anyone know what the problem is?