I am using ACCESS 2000 as the db (not by choice, but by ISP restriction) for a website I am creating. I am managing the connection thru ADO in ASP.
Whenever an error occurs while attempting to update/insert any memo field with a long string of text, two things are happening:
1. It doesn't work. I receive an Execute error. I am resigned (almost) to splitting it up into smaller chunks and updating it that way.
2. The .MDB is now locked up. Windows reports the file as "already in use." I have tried using error handler code (included within each page) to first close the connection and set it to nothing and then process the error. This isn't working (the db is still locked up tight) and can't even be opened directly in Access (reboot seems to be the only cure, but that lasts until the next error).
Without appending code, does anyone have any suggestions? Or should I include a code example?
Code is always helpful. Which version of the Jet Provider are you using ? Which version of mdac are you using ? Are you using client-side or server-side cursors ? What is the error message you are receiving ?