bposthumus:
My output path contained all the correct and required slashes, sorry that I did not post it:
tempWS = "E:\\FMP_Reports_Tool\\tempWS.mdb\\"
_garret_:
I originally had used the Value table method but it kept crashing so I switched to creating the string.
I followed a number of your ideas, changing all my paths from \\ to /, and using the os.path.join (tempws, tableName)... which didn't work either!
Just in a round about sort of trial and error, frustrating , smash my face on the keyboard, way, I started switching some of my inputs back to the way I had before I tried your methods...
Some where in the middle it worked!
So I have a bit of a spaghetti factory code, all mixed up using various different methods to create the out puts and it works and I don't want to touch a thing. So dirty it will stay.
I am still not sure why it wouldn't work though I suspect it possibly could have been the cursor used to create the list or value table, holding a lock on the variable? I dont know.
Any way thanks again everybody for the suggestions. Today I am a Happy Gisser!