Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread Another index problem 4.26
Wed, Apr 1 2009 8:52 AMPermanent Link

"m.malagoli"
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!

Wed, Apr 1 2009 9:15 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

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]
Wed, Apr 1 2009 10:35 AMPermanent Link

"m.malagoli"
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]
>

Wed, Apr 1 2009 10:44 AMPermanent Link

"m.malagoli"
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]
>

Image