Link to home
Start Free TrialLog in
Avatar of Alaska Cowboy
Alaska CowboyFlag for United States of America

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.
ASKER CERTIFIED SOLUTION
Avatar of puppydogbuddy
puppydogbuddy

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Alaska Cowboy

ASKER

PDP,

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
Avatar of puppydogbuddy
puppydogbuddy

Bill,
Glad I could help.  Thanks for the points and grade.