Access2000 & sequence as primary key in view : #DELETED

Hi list !

I created a view in postgresql (quite complex, multiple tables are
linked). The aim is to link it in acces via ODBC.

In needed to auto-number the rows, and I created a sequence for that
(thanks to a good advice on the GENERAL list).

In Access, I know that I need good primary keys on my linked tables
(integer, single column). I though that using this column as a primary
key would be a good idea .

The view looks like this :
CREATE OR REPLACE VIEW my_view AS
SELECT nextval('my_view_seq'::regclass)::integer AS "index", <many
other fields> FROM <many tables>;

Note I had to explicitely cast the sequence as integer, because it was
detected as a decimal field in Access (equivalent to NUMERIC in
PostgreSQL).

In Access I link my tables via some VBA code. I have a routine that
creates the primary keys when they are non-trivial. In this case, the
routine executes "CREATE UNIQUE INDEX my_pkey ON TABLE my_linked_table
(index)".

The primary key is created OK, the column is recognized as
integer-type in Access, but when I open the table all the fields are
marked as #DELETED.

Where exactly is the problem here ?
Is it just impossible to use this sequence-generated field as a
primary key in Access ?

Thanks for your help on this !

--
Arnaud