In version 4.26 I create a new DB and then "create index if not exist" in a
table and if I try to open the same table from another program before close
and reopen the first one i receive a "11013 Acces denied"

Any suggestion?
thanks!

m.malagoli


That is correct. Creating a table or an index on the table requires exclusive access so you need to close the table you've just created / altered to allow other access to it.

Roy Lambert [Team Elevate]

Sorry but is not clear fo me...
If i create a new table the table is closed
Ok during the index creation but after why other process cant access the
table?
The problem appear when i open the table becomes exclusive
There is a workaround?

thanks


"Roy Lambert" <roy.lambert@skynet.co.uk> ha scritto nel messaggio
news:63B34BB0-6D03-450C-ACC3-939AA8463610@news.elevatesoft.com...
> m.malagoli
>
>
> That is correct. Creating a table or an index on the table requires
> exclusive access so you need to close the table you've just created /
> altered to allow other access to it.
>
> Roy Lambert [Team Elevate]
>

SORRY.....
i have found the problem...
a piece of code that set Exclusive = true out of control

Thanks anyway

Mirco


"Roy Lambert" <roy.lambert@skynet.co.uk> ha scritto nel messaggio
news:63B34BB0-6D03-450C-ACC3-939AA8463610@news.elevatesoft.com...
> m.malagoli
>
>
> That is correct. Creating a table or an index on the table requires
> exclusive access so you need to close the table you've just created /
> altered to allow other access to it.
>
> Roy Lambert [Team Elevate]
>