Results 1 to 14 of 14
  1. #1
    Join Date
    Sep 2006
    Posts
    10

    Unanswered: acc2002 error 3799

    I'm getting an error 3799 when I try to open my Acc2002 file.

    The error appears whenever I attempt to open the file in any way (including the repair function). Jet Comp produces the same result.

    Any ideas on what I should do to either fix the file or recover the data?

    Please let me know.
    Evan

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    First of all, backup the recalcitrent db. Next open a new blank db, then import all the objects; forms, queries, macros, and do'nt forget the modules, if any. Name the new db anything you like, delete the old db and rename the new one to the old one's name. Hope it works!
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Sep 2006
    Posts
    10

    can't import

    Hey Missingl...
    thanks for the reply.

    The error is still popping up when I do File > Get External Data > Import. So I'm not able to open the database enough to get the objects out.

    The database is also password protected, and the error appears right after I enter the correct password.

    Any suggestions?

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    What is the 3799 RTE??? The actual error message itself ...
    Back to Access ... ADO is not the way to go for speed ...

  5. #5
    Join Date
    Sep 2006
    Posts
    10
    The message appears right after I enter the correct password, and it is:

    Could not find field 'ObjectID'

  6. #6
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    There is a way to repair password protected DBs by using the ODBC Repair option in a DSN ...
    Back to Access ... ADO is not the way to go for speed ...

  7. #7
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Maybe the Grand Poobah's idea will work. I don't have any other ideas; never had this kind of problem. I'll follow along when I can, but Hurricane Ernesto's come to town ad my broad band connection has been down much of the morning.
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  8. #8
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926

    Error

    Would opening the database from a command prompt with the /decompile parameter work? (I think it's /decompile although it's been a while)
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  9. #9
    Join Date
    Sep 2006
    Posts
    10

    struggle continues

    Hey All, thanks for your replies.

    M Owen: What is a DSN? You said that "There is a way to repair password protected DBs by using the ODBC Repair option in a DSN ..." What does that mean? I'm not familiar with that term and if it's a program I need to use, where do I get it?

    Please let me know

    Cheers,
    Evan

  10. #10
    Join Date
    Sep 2006
    Posts
    10

    the /decompile

    Using /decompile doesn't seem to work on my version (2002) of MS Access.

    Any other ideas?

    Or in another vein of thought, is there a data recovery program that anyone would highly recommend? I've found a few products out there, but, having not done this before, am looking for any particularly good recommendations.

    Please let me know.

    Cheers,
    Evan

  11. #11
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by evan_klassen
    Hey All, thanks for your replies.

    M Owen: What is a DSN? You said that "There is a way to repair password protected DBs by using the ODBC Repair option in a DSN ..." What does that mean? I'm not familiar with that term and if it's a program I need to use, where do I get it?

    Please let me know

    Cheers,
    Evan
    Try your Control Panel->ODBC Data Sources->File/User/System DSN

    Then add the Access DSN of choice (I use the System) then in there is an option to repair ... Of course, after you have selected the DB thaty the DSN points too ...
    Back to Access ... ADO is not the way to go for speed ...

  12. #12
    Join Date
    Sep 2006
    Posts
    10
    I haven't found "ODBC data sources" in my control panel. I'm using Windows XP. Maybe it's not in that version?

    Any other suggestions?
    Can anyone recommend software for data recovery?

    Cheers,
    Evan

  13. #13
    Join Date
    Sep 2006
    Posts
    10

    found the ODBC

    Ok. I found the ODBC in the "administrative tools" part of the control panel. I ran both the "repair" and "compact" options with the file, and both times, the same error message came up.

    So I'm still at square one.

    Any suggestions anyone? HELP!

  14. #14
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by evan_klassen
    Ok. I found the ODBC in the "administrative tools" part of the control panel. I ran both the "repair" and "compact" options with the file, and both times, the same error message came up.

    So I'm still at square one.

    Any suggestions anyone? HELP!
    You've tapped all the options I know of ... Maybe Wayne Phillips has an idea ... He run an Access DB repair company and site ... Don't know it off the top of my head tho ... Ah, got it: http://www.everythingaccess.com
    Back to Access ... ADO is not the way to go for speed ...

Posting Permissions

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