On Wed, May 04, 2005 at 10:56:25 +0200, Zlatko Matic <zlatko.matic1@xxxxxxxxxxx> wrote: > I will try...if it will be useless, I will quite. Then the only solution > will be make-table query based on nested pass-through query, so I will be > working on local JET tables that will be refreshed from server on each > session. But I would like to avoid local tables, if possible... Didn'y you ask this same question a week or two ago? I am pretty sure someone told you how to make access work with a view. > How do I create sequence ? You can't create a sequence for a view. You would need to have it in a table that is joined as part of the view. ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match