Curious howhard would it to be to just create a new database with all the tables and then transfer in the dataso all fields are correct like all my other sites but then I can still have my data? Would this be a option to go with?
I don't know if Access supports importing just the data... you could write a small script to handle it - but it still begs the question: will that fix the problem?
Do you know what the table structure is vs. what its supposed to be? It could be easier to fix the existing table...
No clue I really have done nothing with databases to tell you the truth. 4 months at this and I can read the dbs script sort of. But would be willing to learn if someone would or could point out what I should be looking for.
Have you used a respose.write to double check the variables being passed through the SQL string, just to be caertin sure it ain't nothing going awry in your code?
Search is your friend “I was having a mildly paranoid day, mostly due to the fact that the mad priest lady from over the river had taken to nailing weasels to my front door again.”
No I haven't to tell you the truth I am not 100% sure how to do that I tried doing a couple things Huw and Davio said to do and I think I am messing it up somehow. So really not sure. Seems like the not sure keeps coming up for me in the last week. lol
Topic Locked
Posted - 26 January 2007 : 11:11:03
But would be willing to learn if someone would or could point out what I should be looking for.