Lock a table until Package execution finishes

Hello,
I need to lock a table in startup of my package so that access calls from other applications are put on "wait" by sql server until I unlock.

Any idea how would I do it ?
Or is it possible or not ?

Thanks,
FahadIf you use MS Access database I think it will be locked automatically.|||You may want to jump over to the Transact-SQL forum to get help on this. I would imagine you can issue a table lock command in an Execute SQL task, and then when done processing release that lock in another Execute SQL task.

local system question

If I remove builtin\administrators will this prevent local system from being
a potential startup account?
TIA,
John"John Brown" <anonymous@.discussions.microsoft.com> wrote in message
news:670DC55B-F707-41AF-9B1F-18B6DCEDFA89@.microsoft.com...
> If I remove builtin\administrators will this prevent local system from
being a potential startup account?
No
Steve|||Well I don't know if this is the same problem but it may be a clue. I recen
tly ran into trouble with an access front end on a workstation that suddenly
wouldn't connect to the server. It wouldn't connect using the server name
nor would the name show up
in the drop down list. As it turns out it was a hijack virus that two diffe
rent scanners didn't detect. It took control of that machine as it tried to
connect to the server using the name of the server. So I just used the ip
of the server to connect an
d it works. So it may be a virus.|||John,
It doesn't but if your SQL Servers are clustered then you will need to make
sure the cluster account can still access SQL Server. It usually does so by
using the BUILTIN\Administrators logon. There is also a problem with Search
Service:
FIX: Microsoft Search Service May Cause 100% CPU Usage if BUILTIN\Administra
tors Login Is Removed
http://support.microsoft.com/defaul...034&Product=sql
INF: How to impede Windows NT administrators from administering a clustered
instance of SQL Server
http://support.microsoft.com/defaul...712&Product=sql
There are probably a few more KB articles I don't remember.
Randy Dyess
www.Database-Security.Info