.dbf linked to access

[coned]

Using Access97 to link to a foxpro table - I am suddenly unable to read the foxpro table either in datasheet view or using an access query. This is only happening on one of my tables and it used to work! What could be wrong with this table and what can I do? The error that I receive in Access is "Invalid Operation" the text available upon clicking the help button on the dialog box is:
***
Possible causes:

· You tried to write to a read-only property. See the Help topic for the property to determine whether it is read/write.
· You tried to use a method or property on a type of Recordset object that the method or property doesn't apply to. See the Recordset object Summary topic to determine which methods and properties apply to a given type of Recordset object.

· You tried to append a property to a Properties collection of an object that doesn't support user-defined properties.
· You tried to use the Update method on a read-only Recordset object.

 

[craigsboyd]

You may have more luck in the access forum. A few questions none-the-less... Have you tried to open and browse the table with VFP (this may tell you if the table is corrupted)? What is the code that causes the error? Are you using the exact same code on the other tables that work? Do you have a back-up of the table from when it worked that you can test and see if it is truly the table causing the problem? From when it worked to when it didn't work did you change any of the pertinent code?

Slighthaze = NULL

[ul][li]FAQ184-2483
An excellent guide to getting a fast and accurate response to your questions in this forum.[/li][/ul]

 

[torturedmind]

also, make sure that the table was not deleted, renamed or moved from it's original filepath.

kilroy

 

[rgbean]

coned,
Are you using the VFP OLE DB provider, or the VFP ODBC client? If you are using the "default" DBF access, and the table got changed to type VFP, you won't be able to access it - it only hanfles Fox 2.x type tables.

Rick