G
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
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