Gilles:

As Appreg01 is a VFP free table and is the table that needs to be shared/accessed by all of the Codemine sessions, it needs to be accessed centrally. I know "diddly" about DB2 and AS400's but, the only way I could see around this is structure a DB2 table the same as Appreg01. Copy the Appreg01 data to the DB2 table. Then, set up a view based on the DB2 "Appreg01" equivalent table and call the view 'Appreg01'. If this worked, the main problem I could see is the need for you to update the DB2 data source quickly because obviously, counter values would be out of synch in each view of "Appreg01". For this reason alone, it sounds like a bad idea.

Other thing would be housing Appreg01 on a centrally available machine on your PC network. As long as the Codemine sessions can access said machine, that would probably be OK too.

Otherwise, I would suggest speaking to Dave Lehr at Soft Classics who would, at the end of the day, be the best person to ask.

HTH

>Hi !
>I allready asked the question but no answer for the moment...
>
>I am working on a client server application with Codemine and views on a DB2 database on AS400...
>I would like to have also the local base (Appreg01) with security and counter values for the primarykey() function on DB2...
>
>Is it possible ?
>
>Thanks !
>
>Gilles