[RESOLVED] MSDE same as using MDB?

[ober0330]

We've been using local Access databases for keeping track of local stuff, but we now have a SQL 2000 server running most of our stuff. We have one app that runs on various PCs that writes to a local Access database.

What I'd like to do is run a local version of a MSSQL database on those PCs so it's easier to update the global SQL server as I see fit.

My question is:

How do I go about creating a local MSDE file and writing to it/interacting with it?

I plan to use ADO and I know how to connect to a database and all that, I just don't know if I need to have something like SQL express running on each local machine or not. I was hoping the process would be similar to using a MDB file.

Help?