When you design your remote views of the Access tables, do NOT make the key ID field updatable. This will force Access to autogenerate the unique ID for inserted records.
>Hello All,
>I've created a db with remote views to access tables. I've made the necessary fields updatable, I selected the checkbox for Send SQL updates and save the view.
>
>Within a form I "append blank", do the data entry, and issue the =tableupdate(.t.) command. BUT, it's returning false and not updating or adding the enw record.
>
>Any ideaas of what I'm doing wrong??
>
>Sandy
Mark McCasland
Midlothian, TX USA