Dear Experts,

when i try to truncate table in the linked server ( linked to MS Access database) like:
truncate table LSchools...Payment
it will give the error:
maximum number of prefixes. The maximum is 2

when i use the statement like :

delete from LSchools...Payment

it will give the error like

File sharing lock count exceeded. Increase MaxLocksPerFile registry entry

( where payment may have more than 100.000 records)

I increase the MaxLocksPerFile to 120.0000 on the server registry

it works , but it is taking long time to execute.

1.Is there a way to use truncate?
2.Is there a way to execute MS ACCESS Query from (query analyzer), like ('Delete * from payment') where this is fast and no record locking encountered

Many Thanks