I want to use SQL Server as backend database and VB 6.0 as front end. But I am very new to MS SQL Server. I want that no normal user can delete database/tables or database structure nor he can make big changes to database except editing and adding data. So I have some questions, please help me.
...will installing sql server on Win2k server computer which is on workgroup, serve our purpose(like security reasons & user permissions).
...how to create users/tables/database/permissions/login accounts on sql server on workgroup.
...how to connect to this database through LAN/workgroup i.e. how to setup connection to this database within from VB 6.0.
Thanx in advance.