I am trying to convert a program from MySQL to MS Access (don't ask)
my problem is I am having trouble trying to get the data to insert into the MS Access Table.
I am using a DSN=less connection
database name is School.mdb
table is users
/------ code snippet
$conn = odbc_connect("School", "", "");
$stmt = odbc_prepare($conn, "INSERT INTO users (UID, username, password, name, admin, school) VALUES ('', '$userName','$userPwd','$realName','$userSchool','$userAccess');" );
$result = odbc_execute($stmt) or die ("ODBC Error");
------/
I am getting a fatal error somewhere because as per the code it prints "ODBC Error"
I really need some help with this one.
Thanks Mike
