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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VFP ODBC problem

Status
Not open for further replies.

dchristensen

IS-IT--Management
Sep 22, 2002
74
US
WE are using a VFP-based CRM package. Because of it's reporting limitations, I have set up a DSN and use Access to generate adhoc reports requested by my management. Recently, I added some additional columns to the primary table and since doing so, I have been unable to open the table(s) in Access. I refreshed the link, I deleted and recreated the DSN, to no avail.

The errors I'm getting report that "the record is too large". Is there a parameter that I can change that will allow me to access the .DBF tables via Access?

Thanks!
 
The errors I'm getting report that "the record is too large". Is there a parameter that I can change that will allow me to access the .DBF tables via Access?

You might have a better chance posting this in the Access forum since it seems to be an Access problem.



Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.
 
Thanks, Mike.

I thought to post it here because I thought it was a VFP ODBC issue.
 
dchristensen

What kind of field is it? Memo? General?

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.
 
I'm getting the Error# in every field, in every row for the table. Before I recreated the DSN, it wouldn't even try to display the table in grid view, but would just tell me that the record was too large.

What's interesting is that I can move the data to MySQL and can open the table with no problems in Access.

The reason that I'd like to do it in Access is that I have a situation where someone deleted an agent record and I'm trying to open a restored version of the table so that I can cut and paste the missing person back to the active table. Not able to do that, I'll have to find another way to get it done.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top