hello,,,

if i use access database with many clients in my app. and i have to insert or delete or update any data in the database i connect to the database and do whatever then i close the connection,, this was in access,, my question is,, should i do the same in SQL Server 2000?? i have about 5-8 clients will use the same database server,, should i connect to the database at the start of my app and close the connection in the end of it,, or should i do the same as access database,, i mean connect - do whatever - close at every time i have to something in the database????

please help...
thanx