Want to setup a network for access db. Do I need client server or peer to peer?

[pbaldy]

And another question in addition to my question just above - does anyone know some training/certification courses I can take for either SQL Server and/or MySQL? I found some from learning tree for SQL Server for about $5000-6000. Does anyone know of anything like this that might be better? Thanks

My training on SQL Server is all from the school of hard knocks, so I don't have a recommendation but I would throw out a caution. I took a network class years ago and was very disappointed. It was totally geared towards passing a certification test. It didn't teach you how to use various tools, or why you would use one tool over another in a given situation. It may have been very helpful for passing the test, but was worthless from a practical standpoint.

If you find a course, make sure it's going to teach you the "how's and why's". To compare to Access, you don't just want to know that to create a form you go to the Create tab on the ribbon. You want to know the differences between a datasheet and continuous form, the advantages and disadvantages of each and why you might use one over the other. When/why you'd want a form/subform arrangement.

[pbaldy]

By the way, it would probably take a while to get to 10Gb. I've got a db in SS that probably has over 10 million records over a few tables and I think it's at 4Gb.