>>If you mean that you use VFP interface connected to VFP tables using remote views, than you probably took wrong way, just because using local views you will get the same thing but avoid one (redudndant, in this case) ODBC layer. Surely, unique ID generation will work the same way in both cases.
>
>I know that I can set the exclusive property on the local views of my data session, but this isn't possible with Remote Views. And I'm using them because I need multi-user access to the same tables, that need to be located on a server computer. I don't know how to implement a different solution.
>I know what I should do to generate an unique id, but I don't know a way to lock the table used to store the latest index...
Remore views and ODBC are both used when you should connect to non-VFP data source (usually RDBMS as SQL-Server,Oracle,Sybase,etc). If you use VFP data you should take normal way working with local views and/or plain tables. Local view is always exclusive because it always exists locally, so don't worry about this. Actually multi-user integrity supported by buffering and generic app flow.
Edward Pikman
Independent Consultant