Insert error, both in VBA and sql (Reserved error (-1517); there is no message for this error)
Posted on 2006-11-07
Very weird - - - in a section of code that's been successfully tested, I'm getting an unusual error: "Reserved error (-1517); there is no message for this error"
It took me a while (well, 15 minutes) to track this down, but it turns out the linked table was bad.
I could insert into the back-end successfully, so I re-did the link and all was well, this happened for two tables. I've never seen this in 2 years of pretty active Access work.
I was able to solve the error but it's nerve-wracking to have this happen. What if this happens to a user? it's a fatal error that requires a surgeon . . .
Is this common, or perhaps not unheard of?