Results 1 to 3 of 3

Thread: Runtime Err '-2147467259' VB6 MS access

  1. #1

    Thread Starter
    New Member
    Join Date
    Mar 2005
    Location
    S.Wales (UK)
    Posts
    7

    Question Runtime Err '-2147467259' VB6 MS access

    Hi there everyone ,
    Gotta small problem that im hoping to get solved as soon as poss! Here we go.....
    Im developing a small user maintained database that I am using to store repair records. Im still fairly new to DB development, but have managed to produce a table that i can view & delete records etc.

    Problem is, when adding a new record I get Err message '-2147467259' which reads "Empty row cannot be inserted. Row must have at least one column value set."

    Now im not quite sure what this means exactly, but my database does get updated correctly with the new info.
    I've tried the On Error Resume Next to try to ignore it, but this method doesnt seem to operate as it should.

    I'd be more than greatful for any help on this, Cheers All who read this !!

  2. #2
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    Re: Runtime Err '-2147467259' VB6 MS access

    How are you adding the new row?

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...

  3. #3

    Thread Starter
    New Member
    Join Date
    Mar 2005
    Location
    S.Wales (UK)
    Posts
    7

    Thumbs up Re: Runtime Err '-2147467259' VB6 MS access

    Hi there ecniv, Thanx 4 ur interest in my problem, but i av just found the solution to it. Took me a good while tho, Cheers Anyway!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width