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!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ODBC link to Visual Foxpro

Status
Not open for further replies.
RichardH

RichardH

Programmer
Apr 21, 2001
46
US
I am trying to setup a link to Visual Foxpro tables using ODBC. I am able to open all of the tables except one. When I try to open it I get the message:

"The form or report is based on a query that exceeds the limit for data in a single record"

The Visual Foxpro table has 169 fields with a total length of 4672. Does this mean Access has a limit on the number of fields or the size of the record? What is the exact limit?

Thanks...
 
Status
Not open for further replies.

Similar threads

BallunarCrew
  • Solved
ODBC Driver Struggles on new computers
Replies
3
Views
625
BallunarCrew
BallunarCrew
TheresAlwaysAWay
  • Locked
  • Question
Can Access be used to generate and respond to text messages? 1
Replies
6
Views
5K
TheresAlwaysAWay
TheresAlwaysAWay
renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
987
renigar
renigar
YoBi4Ever
  • Locked
  • Question
I would like to compute how many minutes or hours the employee left work by comparing two records
Replies
3
Views
383
dhookom
dhookom
TheresAlwaysAWay
  • Locked
  • Question
Crazy question: Can anyone help me create a routine to roll 2 dice 1000x and sum them? 4
2
Replies
22
Views
6K
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top