Alaska Cowboy
asked on
Insert error, both in VBA and sql (Reserved error (-1517); there is no message for this error)
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?
Thanks.
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?
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Bill,
Glad I could help. Thanks for the points and grade.
Glad I could help. Thanks for the points and grade.
ASKER
thanks, you sure have a wealth of info at your fingertips.
The article confirms what I found and makes sense given that I was fiddling with the schema. So I'll be able to better respond next time.
Bill