Page 1 of 2 12 LastLast
Results 1 to 15 of 21
  1. #1
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713

    Unanswered: Challenge: Get an Access DB to error out with a 3343 RTE deliberately ...

    Hi all.

    Yep. I can't. Been trying to do so for 2 days ... So, if anyone can figure out a way to blow an Access database with the runtime error 3343 "Unrecognized Database Format" and can tell how, I would be most appreciative on how it was done ... I have some ideas but every single 1 of them have bombed out (did not error out the db) ... It's not every day you see a posting of HOW TO kill a db ... Usually it's how to prevent the killing of the db ...

    Thanks!

    ... and no, lobbing nukes won't do it either ...
    Back to Access ... ADO is not the way to go for speed ...

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    hi Mike,

    i have been following your (possibly) related posts with some interest.

    as an ardent DAOist (cf your fervent ADOism) mewonders if this is not some desperate pre-Vista attempt by the ADO camp to prove that you can break DAO if you do something mad enough (with the hoped-for implication that ADO is "better" so DAO deserves to die). but that is probably just my paranoia speaking.

    one bit is enough to generate "unrecognised format". try editing byte two in any MDx from 01 to 00. the substantive "data" part is the same, but the malformed header kills it (open, import, link, relink).

    izy
    currently using SS 2008R2

  3. #3
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by izyrider
    hi Mike,

    i have been following your (possibly) related posts with some interest.

    as an ardent DAOist (cf your fervent ADOism) mewonders if this is not some desperate pre-Vista attempt by the ADO camp to prove that you can break DAO if you do something mad enough (with the hoped-for implication that ADO is "better" so DAO deserves to die). but that is probably just my paranoia speaking.

    one bit is enough to generate "unrecognised format". try editing byte two in any MDx from 01 to 00. the substantive "data" part is the same, but the malformed header kills it (open, import, link, relink).

    izy
    My ADOism was from my previous employer ... Now, I'm having to go back to the (pardon the slur ) stone ages of DAO ... This is a legit need here. I'm trying to kill the db with a 3343 RTE as a "reproduce" proof ... And hacking the db may work but, I'm really trying to do this thru the front door ...

    Oh, and Iz, my ardent ADOism was only cuase of a misguided thought that DAO could not support DSNs (which now, 3.5 years later, I have found out how to with DAO) ... The thing I DO LIKE about DAO is that there's no 5 sec lazy write delay in the DAO object like that in ADO ...

    Cheers.
    Back to Access ... ADO is not the way to go for speed ...

  4. #4
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    that single-buffer thing!
    wonderful.
    anyway, enough of life in general.

    a one-bit-hit is easily implemented in A-VBA, does not fix with C&R, but you tell me this strategem is beyond the rules of this game.

    what are the rules?
    if i can't break it, i'll try one of my retired colleagues - he regularly crashed notepad!

    izy
    currently using SS 2008R2

  5. #5
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by izyrider
    that single-buffer thing!
    wonderful.
    anyway, enough of life in general.

    a one-bit-hit is easily implemented in A-VBA, does not fix with C&R, but you tell me this strategem is beyond the rules of this game.

    what are the rules?
    if i can't break it, i'll try one of my retired colleagues - he regularly crashed notepad!

    izy
    Rules? Break it anyway you can thru the front door ... In Access itself or any app that uses Access ... Except for an app that hacks the 2nd byte in the header ...

    The preferred method is read/write to a table open/close of the database with interruptions of those activities that would cause the 3343 RTE ...
    Back to Access ... ADO is not the way to go for speed ...

  6. #6
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    poss a fun project for the w/e

    some clarifs needed...
    split FE/BE or programmatic import or ??
    datasource format: MDB, flatfile(exact format), or ?
    single/multiuser?
    any risk of 'diverse' regional settings?

    izy
    currently using SS 2008R2

  7. #7
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by izyrider
    poss a fun project for the w/e

    some clarifs needed...
    split FE/BE or programmatic import or ??
    datasource format: MDB, flatfile(exact format), or ?
    single/multiuser?
    any risk of 'diverse' regional settings?

    izy
    I thought you had read up? VB6 & A97 as I recall... DAO 3.51 I think.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  8. #8
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by izyrider
    poss a fun project for the w/e

    some clarifs needed...
    split FE/BE or programmatic import or ??
    datasource format: MDB, flatfile(exact format), or ?
    single/multiuser?
    any risk of 'diverse' regional settings?

    izy
    db access: Can be anything FE/BE, single Access app, external app access (VB, VC, etc ...)

    Format: Corrupted Access db ... With 3343 RTE

    Source: Existing Access db

    Users: Single or multi ... Sit here is quasi multiuser (multiple connections open)

    Regional settings: Nope don't think so

    How to get it anyway you can except for bit twiddling hacks ... Everything else is fair game ...
    Back to Access ... ADO is not the way to go for speed ...

  9. #9
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    poots: sure i read up, but (unless i missed a thread or three) this is not the original flatfile-with-dangling-connections.

    Mike: if Mme Izy will allow me some keyboard-minutes, i will try to break a db to 3343 (but forget 3.51/VB6/A97!)

    happy w/e all.

    izy
    currently using SS 2008R2

  10. #10
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by izyrider
    poots: sure i read up, but (unless i missed a thread or three) this is not the original flatfile-with-dangling-connections.

    Mike: if Mme Izy will allow me some keyboard-minutes, i will try to break a db to 3343 (but forget 3.51/VB6/A97!)

    happy w/e all.

    izy
    Iz,

    3343 happens in all versions of Access ... This one here happens to be a97 but I'd be happy if you can break in it 2k or XP or 02 ...
    Back to Access ... ADO is not the way to go for speed ...

  11. #11
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by pootle flump
    I thought you had read up? VB6 & A97 as I recall... DAO 3.51 I think.
    Poots,

    I'm not that evil. Yes, I am evil but hey, I want some help here ... This prob is not exclusive to A97 ...

    If A97/2K,XP/02 can be broke with a RTE 3343 then I'll be happy and THEN try and dup it to A97 ... It should work at 1st blush ...

    But then again ... We're talking MS here ...

    - Mike
    Back to Access ... ADO is not the way to go for speed ...

  12. #12
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by izyrider
    this is not the original flatfile-with-dangling-connections.
    Obviously I didn't do my homework - I don't remember that one

    Quote Originally Posted by izyrider
    happy w/e all.
    And you
    Testimonial:
    pootle flump
    ur codings are working excelent.

  13. #13
    Join Date
    Jul 2006
    Posts
    108
    does it look like this?
    Attached Thumbnails Attached Thumbnails error.bmp  

  14. #14
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by jwalker343
    does it look like this?
    Yes ... We all know what it looks like ...Now, can you reproduce the error?
    Back to Access ... ADO is not the way to go for speed ...

  15. #15
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    If only DBF allowed a simple "lol" as a post.
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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