Well, I'll ask the obvious...do you (or the userid that is being used) have the correct rights on the server/database?
>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.
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place