Recent content by Bastard

I disagree 100%, if the post is relevant to the thread regardless of age, please feel free to post... people need to get over the "reviving old threads". Nobody wants to spend time piecing together a puzzle from 50 threads when they can get it all the info in one spot. Back on topic, thanks for...

Again, you have double quotes inside the statement.. change all the double quotes inside the statement to single quotes OR four double quotes """" EXAMPLE: Your code Like " * Antibody * " The way it should be Like ' * Antibody * ' or if single quotes doesn't fix it, try four double quotes...

I'm thinking it doesn't like the quotes inside the SQL string... change them to single quotes strSQL = "SELECT dbo_Patient.PatientId," & _ "dbo_Patient.HospitalID," & _ "dbo_Patient.lastnm," & _ "dbo_Patient.firstnm," & _...

I know this is an older post, but i had this problem and after searching , I didn't find an answer... BUT, after messing around with the database for a while, I figured it out perform a compact and repair... then retry converting it hope that works for all you googlers