What? How? Add/Amend/Delete using forms...

[Sensibilium]

I've got an SQL Server MDF DB, and I want to be able to add/amend/delete records using online forms, but how do I stop non-administration people getting through and meddling with my data?

My SQL DB has only 1 username ('sa') and no password, I can't seem to add any admin users, or add passwords. The SQL Server I'm running was installed from the Office 2000 CD (MSDE)...

Do I need a 'Users' table? How would I implement the Permissions?

It's all too confusing! Help! [sig]<p>ahdkaw<br><a href=mailto:ahdkaw@ots.zzn.com>ahdkaw@ots.zzn.com</a><br><a href=

http://sensibilium.com/>Sensibilium</a><br>'If

anythign can go wrong, it will'[/sig]

 

[Sensibilium]

Don't worry, I got this sorted. My webspace provider is just setting a NT password on the admin folder.

If only I'd known sooner! [sig]<p>ahdkaw<br><a href=mailto:ahdkaw@ots.zzn.com>ahdkaw@ots.zzn.com</a><br><a href=

http://sensibilium.com/>Sensibilium</a><br>'If

anythign can go wrong, it will'[/sig]