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.
***
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.