Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Access to dbc conversion
Message
 
 
À
31/01/2004 17:28:31
Randy Riegel
Zimish Contracting
Ohio, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Produits tierce partie
Divers
Thread ID:
00872707
Message ID:
00872777
Vues:
22
Randy,

The VFP tables you are trying to will have to be part of a DBC if any of the column names have more than 10 characters.

I don't use access enough to know it that well, but it sounds like it access is allowing some characters in the field names that aren't allowed in VFP. You should pick debug where the error pops up and examine what is happening on the line of code. If you can give us the actual line of code and the values we can probably help you isolate the root issue. If it's a disallowed character a simple chrtran() added to the code can solve it. It might also be a field type problem. Why not post the access table definition that is erroring out.

>I'm trying to convert a access 2000 database into a vfp dbc. There are tons of tables and I don't want to do it manually because from Access it will only let me create free dbf files so the field names and everything get truncated to 10 characters. I tried using the MDB2DBC program but it keeps crashing on certain tables. Anybody else use any utilites similar to this that works great?
>
>BTW, the mdb2dbc program keeps getting the error when trying to create the vfp table. This is on line 47 of the cmdFinish.Click event. Anybody out there fixed this problem if they have had it?
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform