Greenhorn needs help putting db on server

[gregmoon]

I have a very elementary access 2003 dB that I created to keep up with customer info at work. It contains a dozen or so fields of info that are used in reports to keep up with everything. I also use an excel add-on to merge some of the data into ms word forms. This thing has caught on and now everyone is running the dB separately on several personal computers with each having its own different set of customers/info. It didn?t take long to become obvious that, because we all need different customer info at times, this dB needs to be on the server with everyone's data in it and accessible to everyone. (I got permission today to put it on our server that is running windows server 2000-all the pc?s are running xp pro).

If I take all the data from everyone?s dB and place in one db on the server, how can I fix it so each pc is still able to keep up with the customers they have on their pc? I want to keep what I have (my customers) on my PC, but be able to use (update or merge data to forms) any of the other data I might need as well (that was originally on a separate dB on the PC down the hall, but will now be on the server) Will I need to add something to differentiate each PC?s customer base? Or, can I put everyone?s dB on the server separately and have it so we can access each other?s if we need to? What other kind of snags might I run into when I do this?

As I imagine you can tell by now, I?m pretty new at all of this and would appreciate any suggestions or directions or insight to make this happen.

Thanks,
Greg

[Jacob Hilderbrand]

If you have a field for UserID or something like that, where you enter your UserID when adding data, then you could query by that field later on to get just your data.

[boneKrusher]

I am not sure I understand. Do you want to combine the Databases?

[Jacob Hilderbrand]

He wants to use one database, currently each user has their own. So initially they will be combined into one, then that will be the only one that is used.