I am trying to create a remote view in vfp7 to a table in microsoft access database. When I do add in remote view I see all the ms access tables. When I select add a table (the table is called UDFields) I get following message:

Connectivity Error: [Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no read permission on 'UDFields'.

I am trying to insert and also update exist data in the ms access table (which I'm not quite sure how to do either), but I can't seem to get past this point.


Thanks
Nick Patel.