Sign Up |  Live StatsLive Stats    Articles 35,345| Comments 159,790| Members 17,820, Newest waheguruhelpme| Online 239
Home Contact
 (Forgotten?): 
    Sikhism

   
                                                                     Your Banner Here!    

Sikh Philosophy Network » Sikh Philosophy Network » Current Affairs » Information Technology » " Invalid Argument" error (# 3001) - Conversion Access 97 to 2002

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

Our Donation Goal : Why Donate? : Donate Today! : Donate Anonymously (ਗੁਪਤ) : Our Family of Supporters
Goal this month: 400 USD, Received: 35 USD (9%)
Please Donate...
Related Topics...
Thread Thread Starter Forum Replies Last Post
VBA Access - Moving parts of a program to DLLs? Error 91.. "Object variable or With block variable not set" axs221 Information Technology 10 28-Jul-2006 08:41 AM
I get Invalid Argument message, record reads #Error, what to do? Ben Information Technology 4 28-Jul-2006 08:38 AM
Using a variable in a "DoCmd" VBA argument George Walsh Information Technology 2 28-Jul-2006 08:09 AM
error invalid argument error aagghhhh! freelancer Information Technology 0 11-Nov-2005 20:09 PM
Access 2000 opens in "restore down" not "maximized" format. Art Information Technology 2 27-Oct-2005 08:59 AM


Tags
2002, 3001, access, argumentquot, conversion, error, invalid, invalid argument, quot
Reply Post New Topic In This Forum Stay Connected to Sikhism, Click Here to Register Now!
  #1 (permalink)  
Old 28-Jul-2006, 08:25 AM
fred_y_Ohio's Avatar fred_y_Ohio
Guest
 
Posts: n/a
   
   
" Invalid Argument" error (# 3001) - Conversion Access 97 to 2002

  Donate Today!   Email to Friend  Tell a Friend   Show Printable Version  Print   Contact sikhphilosophy.net Administraion for any Suggestions, Ideas, Feedback.  Feedback  

Register to Remove Advertisements
Help! Conversion of Access 97 DB to 2002 is failing.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/11987-invalid-argument-error-3001-conversion-access.html

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11987
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





 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 28-Jul-2006, 08:25 AM
RuralGuy's Avatar RuralGuy
Guest
 
Posts: n/a
   
   
Re: " Invalid Argument" error (# 3001) - Conversion Access 97 to 2002

On Fri, 23 Jun 2006 11:25:02 -0700, fred_y_Ohio
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.
>
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11987
>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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11987
>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.
Reply With Quote
  #3 (permalink)  
Old 28-Jul-2006, 08:27 AM
Tony Toews's Avatar Tony Toews
Guest
 
Posts: n/a
   
   
Re: " Invalid Argument" error (# 3001) - Conversion Access 97 to 2002

  Donate Today!  
fred_y_Ohio 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11987
http://www.granite.ab.ca/accsmstr.htm
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11987
Reply With Quote
   Click Here to Donate Now!

Support Us!
Become a Promoter!
Gurfateh ji, you can become a SPN Promoter by Donating as little as $10 each month. With limited resources & high operational costs, your donations make it possible for us to deliver a quality website and spread the teachings of the Sri Guru Granth Sahib Ji, to serve & uplift humanity. Every contribution counts. Donate Generously. Gurfateh!
ReplyPost New Topic In This Forum Stay Connected to Sikhism, Click Here to Register Now!

Bookmarks


(View-All Members who have read this thread : 0
There are no names to display.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Tools Search
Search:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On

» Gurbani Jukebox
Listen to Gurbani while surfing SPN!
» Active Discussions
sikhism Who is "Mohan"?
Today 08:46 AM
22 Replies, 331 Views
sikhism How important is Matha...
Today 08:12 AM
59 Replies, 1,037 Views
sikhism need urgent advice.......
Today 06:46 AM
6 Replies, 78 Views
sikhism ਨਾਮਾ
Today 06:37 AM
2 Replies, 51 Views
sikhism Sikh Diamonds Video...
Today 04:23 AM
6 Replies, 115 Views
sikhism Are Creator and Creation...
Today 01:30 AM
44 Replies, 2,835 Views
sikhism Herman Hesse,...
Today 00:54 AM
13 Replies, 228 Views
sikhism On a Scale of Most...
Yesterday 21:42 PM
30 Replies, 1,277 Views
sikhism I became victim by...
Yesterday 19:50 PM
0 Replies, 43 Views
sikhism Sikh Books downloads
Yesterday 15:39 PM
2 Replies, 65 Views
sikhism Salok Sheikh Farid ji...
Yesterday 09:35 AM
0 Replies, 46 Views
sikhism In Punjab, three farmers...
Yesterday 05:36 AM
0 Replies, 48 Views
sikhism Supernatural Sikhs, what...
Yesterday 03:45 AM
19 Replies, 413 Views
sikhism Sukhmani Sahib Astpadi...
26-May-2012 22:57 PM
0 Replies, 49 Views
Do You Think You Are...
26-May-2012 09:59 AM
94 Replies, 8,258 Views
» Books You Should Read...
Powered by vBadvanced CMPS v3.2.2

All times are GMT +6.5. The time now is 08:49 AM.
Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.5.2 Copyright © 2004-12, All Rights Reserved. Sikh Philosophy Network


Page generated in 0.35398 seconds with 30 queries