>Hi All,
>
>I don't know who else to ask about this, so I'll try here.
>
>I have a VFP 3.0 database that a client wants to update using Access. Access 2000 links to all the tables with no problems, but on 2 of the 25 or so tables I can't open the tables in anything but design view. Of course, 1 of these is the one that needs to be changed. The error I get when I try to open the table in Access I get the error "Can't open table xxxxxx in datasheet view". I thought it might be related to the type of data in the table, but other tables open fine using the various data types I have in the trouble table. Also, there are a couple of long stored procedures. Any hints would be greatly appreciated.
>
>TIA
>Bob

Open the tables in VFP and copy them like so:

Copy To mycopy1 Type Fox2x

Or, open them with the ODBC driver.