Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Convert Access Database

Status
Not open for further replies.

mot98

MIS
Joined
Jan 25, 2002
Messages
647
Location
CA
Hi All,

I am attempting to convert an Access 2000 database back to Access 97 format.

However, when I run the convert utility, I am getting the following error:

Invalid Field Data Type

Then it errors saying file could not be converted.

Has anyone seen this before?
mot98
[cheers]

"Victory goes to the player who makes the next-to-last mistake."
- Chessmaster Savielly Grigorievitch Tartakower (1887-1956)
 
Just taking a guess, but..."An Access 2000 database containing a table with a FieldSize property of Decimal cannot be converted to Access 97. You must change the FieldSize property to another value such as Single or Double, or you must change the data type of the field to Currency before you can successfully convert the database."

If this doesn't pertain to your situation, post back with the properties of the field that's giving you this blowup.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top