Multi User database

[clobug1]

We currently have 2 databases, each being data input by 1 person and 1 person only. The PCs are running on a network. When creating a new database to merge both of these old ones it would be really useful if we could have multi users so that both the previous administrators can continue to do their job. I understand that this is possible but don't know how! Apparently it is also possible for other users to be able to access just reports or certain tables, but again have not dealt with this before.

Help!

 

[The_Doc_Man]

I would advise that you find a book such as "MS Access 97 Developer's Guide" or the AC 2k or XP versions of same, then before you buy it, make sure it contains a chapter on setting up workgroup security. All of the things you want to do can be done using that facility. But the answer is way too long for anyone in this forum to type, even me who touch-types comfortably.

 

[clobug1]

Thanks v. much - I may go book shopping tomorrow.

Will this also give me some good explanations of how to decide on relationships as I'm having real problems at the mo. All my tables are in place buy none of them are linked as it's starting to get complicated. I had a thread going on this earlier (in Tables - Linking Tables) but the guy answering me seemed to have missed the point of what I was saying - some of the links need to be created in a particular way in order that I can produce reports for certain groups of people. Any suggestions re. that thread I'd be really grateful as I'm being threatened with it being outsourced at the moment - big cost and lack of control!