This question is for people who know how to code for both MS Access and SQL Server databases.

I want to write some code to create & manage a small database. I can create a SQL db, and I've managed to write some code to read and write records, but I don't really know what I'm doing. I've been shown how to use a wizard in MS Access to create a db. I see that I can access the underlying code and with some effort can figure out how to customize stuff, but alas, still don't know what I'm doing.

My database must be accessible from the (mostly NT/W95) network. I don't know if MS Access can do that. Also, I don't know if MS Access would be installed on all computers, is that necessary to use the "application" or whatever it is you make with it?

Given that I could probably figure out ways to use either tool, which is the *easiest* way to go; the way that would not require weeks worth of research and posts to this message board?

Thanks for anything you got.