Converting error

[Shane Hooper]

Hello, I need to convert my Access2003 database to Access97. It has a
SQLServer2005 back end. When I try I get an error message: Invalid field
data type. Is this somewhere in the coding or in a table itself? Has anybody
encountered this problem? Can someone advise where to look for this invalid
field data type?

Thanks in advance, Shane.

 

[Jeff Boyce]

Shane

From your description, it sounds like there's a datatype in the SQL-Server
backend that Access '97 doesn't know how to handle.

One approach to troubleshooting this might (only might) be to create a new
empty Access 2003 database, and import all of the SQL-Server tables (not
link, import). Then you could try converting that to Access '97 and see if
you get any more specific pointers. If that doesn't work, try converting an
MS Access 2003 database that has only ONE of the tables in it. Then try the
next table, etc. When it breaks, THAT'S the table with a goofy data type.
Dig into it.

Just one person's opinion (JOPO)

Regards

Jeff Boyce
Microsoft Office/Access MVP