This is my sql string it works fine if i use a value instead of a variable. Does anyone know how I can fix this. Its slowly starting to drive me insane.
pstrSQL = "INSERT INTO tblstuff(stuff)VALUES('" & modname & "');"

Thanks,
Matt