Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Access to dbc conversion
Message
 
 
To
31/01/2004 17:28:31
Randy Riegel
Zimish Contracting
Ohio, United States
General information
Forum:
Visual FoxPro
Category:
Third party products
Miscellaneous
Thread ID:
00872707
Message ID:
00872777
Views:
21
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform