Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

" Invalid Argument" error (# 3001) - Conversion Access 97 to 2002

Discussion in 'Information Technology' started by fred_y_Ohio, Jul 28, 2006.

  1. fred_y_Ohio

    fred_y_Ohio
    Expand Collapse
    Guest

    Help! Conversion of Access 97 DB to 2002 is failing.

    I have many Access 97 DBs (.mdb) that I want to convert to Access 2002.

    Some of them convert fine. But some are getting an error that aborts the
    conversion. I cannot figure out how to fix the error. Hoping someone can.
    Specifics follow.

    Error occurs when I open Access 2002, then click on menu
    Tools/DBUtilities/ConvertDB/ToAccess2002FileFormat, after which a navigation
    box opens titled "Database to Convert From".

    In it, I specify the Access 97 DB to convert and click "Convert" button.
    The navigation box disappears and an warning (yellow triangle with black
    exclamation mark) box titled "Microsoft Access" appears, with text "Invalid
    Argument", with two buttons below (OK & Help). I clicked OK and got
    documentation stating,...

    "Invalid argument. (Error 3001)
    You tried to perform an operation that involves a routine in a DLL, and one
    of the arguments to the routine is invalid. Check your entry to make sure you
    have specified the correct arguments, and then try the operation again.
    This error also occurs when you attempt to use mutually exclusive constants
    in an argument to a method, such as specifying both dbConsistent and
    dbInconsistent in the options argument to the OpenRecordset method."

    So, I opened the DB in Access 97 and it works just great.

    I made a copy of it, deleted all queries, forms, reports and macros, leaving
    only tables. Tried converting that version - same error.

    The DB is 8 meg in size. Pretty small.

    Help needed ASAP - looming deadline. Thanks in advance. Fred Yaeger
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Sikh rendered invalid in ’84 riots seeks justice (Gulf Times) Breaking News Mar 14, 2008
    Sikh News 23 years later, invalid Sikh seeks justice (Calcutta News) Breaking News Mar 13, 2008
    Sikh News 23 years later, invalid Sikh seeks justice (New Kerala) Breaking News Mar 13, 2008
    Sikh News 23 years later, invalid Sikh seeks justice (Hindustan Times) Breaking News Mar 13, 2008
    1984 1984 anti-Sikh riots: Sajjan Kumar, others conclude final arguments History of Sikhism Feb 5, 2013

  3. RuralGuy

    RuralGuy
    Expand Collapse
    Guest

    On Fri, 23 Jun 2006 11:25:02 -0700, fred_y_Ohio
    <fredyOhio@discussions.microsoft.com> wrote:

    >Help! Conversion of Access 97 DB to 2002 is failing.
    >
    >I have many Access 97 DBs (.mdb) that I want to convert to Access 2002.
    >
    >Some of them convert fine. But some are getting an error that aborts the
    >conversion. I cannot figure out how to fix the error. Hoping someone can.
    >Specifics follow.
    >
    >Error occurs when I open Access 2002, then click on menu
    >Tools/DBUtilities/ConvertDB/ToAccess2002FileFormat, after which a navigation
    >box opens titled "Database to Convert From".
    >
    >In it, I specify the Access 97 DB to convert and click "Convert" button.
    >The navigation box disappears and an warning (yellow triangle with black
    >exclamation mark) box titled "Microsoft Access" appears, with text "Invalid
    >Argument", with two buttons below (OK & Help). I clicked OK and got
    >documentation stating,...
    >
    >"Invalid argument. (Error 3001)
    >You tried to perform an operation that involves a routine in a DLL, and one
    >of the arguments to the routine is invalid. Check your entry to make sure you
    >have specified the correct arguments, and then try the operation again.
    >This error also occurs when you attempt to use mutually exclusive constants
    >in an argument to a method, such as specifying both dbConsistent and
    >dbInconsistent in the options argument to the OpenRecordset method."
    >
    >So, I opened the DB in Access 97 and it works just great.
    >
    >I made a copy of it, deleted all queries, forms, reports and macros, leaving
    >only tables. Tried converting that version - same error.
    >
    >The DB is 8 meg in size. Pretty small.
    >
    >Help needed ASAP - looming deadline. Thanks in advance. Fred Yaeger


    Maybe something MVP Allen Browne posted will help.
    http://allenbrowne.com/ser-48.html
    _______________________________________________
    hth - RuralGuy (RG for short)
    Please post to the NewsGroup so all may benefit.
     
  4. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    fred_y_Ohio <fredyOhio@discussions.microsoft.com> wrote:

    >Some of them convert fine. But some are getting an error that aborts the
    >conversion. I cannot figure out how to fix the error. Hoping someone can.
    >Specifics follow.
    >
    >"Invalid argument. (Error 3001)


    This can be an indicator of corruption. Have you tried compacting
    the A97 MDBs and trying the import again?

    Tony
    --
    Tony Toews, Microsoft Access MVP
    Please respond only in the newsgroups so that others can
    read the entire thread of messages.
    Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm
     

Share This Page