[AccessD] Error with converting

That is not the case I have. Some mdb contain field as 'Description' without
problem to convert. Some mdb with or without field as 'Description' got the
message " Could not find field 'Description'" at the end. And get db1, db2
two Axxess2K mdb. When I looked at that two mdb. They looks like no problem.

Need further helps!

-----Original Message-----
From: MartyConnelly [mailto:martyconnelly at shaw.ca]
Sent: Thursday, February 13, 2003 15:21
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Error with converting


Run this code below for each table
http://support.microsoft.com/default.aspx?scid=kb;en-us;209187
ACC2000: Reserved Words in Microsoft Access
Then check for reserved words or illegal characters in field names
of course it could be something wierd like code originally created in
alternate language version like french.
Also try doing a decompile, compile and compress before converting.
      
Sub showFldDesc(Intable As String)
'Enumerate Field Descriptions in specified table
On Error Resume Next
Dim db As Database
Dim tdf As TableDef
Dim fld As Field

Set db = CurrentDb()
Set tdf = db.TableDefs(Intable)

For Each fld In tdf.Fields
  Debug.Print fld.Name,  "desc=" & fld.Properties("Description")
Next
On Error GoTo 0
End Sub


Li, Dahuan wrote:

>Hi, listers,
>
>I got error message "could not find field "Description" when I convert a
mdb
>from Access 97 to Access 2000. No help file I can get.
>
>Anything wrong?
>
>Thanks
>
>Daphne
>
>
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>  
>


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com