I am going to be splitting an Access database back-end will be on the server and front end will be on the client. I am some what new at this so I have a couple of questions:

How many times can this be done with the same database (I believe there are 8 computers i need to place the front-end on)?

Can I set up separate user accounts in each front end?

Thank you for your help Bill

How many times can this be done with the same database (I believe there are 8 computers i need to place the front-end on)?

There is a limit to the number of users at any one time but that is over 200. I don't believe there is any limit to the number of access points. Excepting the limitations of your network.

Can I set up separate user accounts in each front end?Bill

Yes set up user security. But my advice would be to develope this befor you move your db.

Be carefull and don't work with the origonal files. Work with a duplicate copy then you can revert if it goes pear shaped. Theres lods of help and advice on these forums on that subject. Just use the search facility and read.--------LOADS.

How many times can this be done with the same database (I believe there are 8 computers i need to place the front-end on)? - Splitting is only done ONCE. The fe is then copied to as many clients as necessary which in your case is 8. All the fe's link to the same be which resides on a server.

Can I set up separate user accounts in each front end? - I'm not sure what you are trying to do. Is it that you just want to know who the current user is? If so, search here for code that you can use to get the user's network ID. If you need to implement security, that's a whole different problem and one that requires EXTREME care as Parker has already mentioned. Make sure that you download the Security FAQ (http://support.microsoft.com/default.aspx?scid=%2fsupport%2faccess%2fcontent%2f secfaq.asp#_Toc493299666) and follow the step-by-step EXACTLY. Make sure you have an unsecured backup so you can recover from a mis-step.