Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Insert error, both in VBA and sql (Reserved error (-1517); there is no message for this error)

Posted on 2006-11-07
3
Medium Priority
?
1,282 Views
Last Modified: 2008-01-09
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.
0
Comment
Question by:Alaska Cowboy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 38

Accepted Solution

by:
puppydogbuddy earned 500 total points
ID: 17889327
Bill,
See the following link from Tony Toew's web site

                http://www.granite.ab.ca/access/reservederror1517.htm
0
 
LVL 1

Author Comment

by:Alaska Cowboy
ID: 17889868
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
 
LVL 38

Expert Comment

by:puppydogbuddy
ID: 17890001
Bill,
Glad I could help.  Thanks for the points and grade.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question