Re: General Error - can I do better than that.

Hi Aaron,

Don't know if you can get a better error description, but on some occasions I had the same problem when working with MS Access db's.

It seems that you get this 'general error' when you insert a row that causes a primary key violation.

Hope this helps,
Axel

aaronfude@xxxxxxxxx wrote:
Hi,

I'm working in Windows with an odbc driver for accessing an Access db.
Some INSERT statements throw exception with the "General Error"
message. Can I do better than that and actually find out what went
wrong? Is this the sort of thing that is DB related? For example,
would MySQL give better error message (in addition to other great
features, of course).

Many thanks in advnace!

Aaron Fude.

.

Relevant Pages

  • Adding field - error "More than one field...."
    ... On 2 or 3 occasions in the database I'm putting together, ... The error message gives no clue as to how to troubleshoot the issue and on ... eachg occasion I have had to rebuild a report from scratch if I wanted to add ... from the Control Source property in the Fields property box, ...
    (microsoft.public.access.reports)
  • Re: Office 2003 reinstall attempt produces CARemove error.
    ... Always the same error message. ... I cleaned the register on several occasions without success. ... Free Computer Help - http://forums.techarena.in ...
    (microsoft.public.office.misc)
  • Newsgroup Site..Error in Replies
    ... On several occasions I reply to a post that was a reply to my posted ... other times I get an error message: ... Makes using the Newsgroup site rather difficult. ... I have emailed to wrhelp@microsoft.com twice to try to solve this and I ...
    (microsoft.public.windowsxp.security_admin)
  • Problems with IF-formula in calculated field
    ... I'm using the wss 2003. ... The error message: ... The formula contains a syntax error or is not supported. ... Is there some general error in the formulas that I don't know about? ...
    (microsoft.public.sharepoint.windowsservices)
  • error message
    ... I am trying to copy a CD I have been successful on two occasions but now am ... getting error message CooD11C9 telling me Windows cannot copy to CD-R ...
    (microsoft.public.windowsmedia.player)