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.
LVL 1
Alaska CowboyAsked:
Who is Participating?
 
puppydogbuddyConnect With a Mentor Commented:
Bill,
See the following link from Tony Toew's web site

                http://www.granite.ab.ca/access/reservederror1517.htm
0
 
Alaska CowboyAuthor Commented:
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
0
 
puppydogbuddyCommented:
Bill,
Glad I could help.  Thanks for the points and grade.
0
All Courses

From novice to tech pro — start learning today.