I've been reading & printing endless threads on 3 different forum websites for days now and my head is going to explode. I need moron-proof step by step instructions because clearly my brain capacity is on the same pathetic level as Kelly Bundy.
All I want to do is take a new database that I've created, put the back end on the shared server and front end on each employee's individual computer so they can view reports and enter data. As Admin I need to be able to make changes to the database as needed. I've done this before with a prior database several years back but I can't remember how I did it nor can I find any notes I may have kept.
I've been tinkering around with the security wizard, user groups, permissions, etc and all I have created multiple problems.
#1 - Now whenever I open any Access database I am prompted for a logon which I don't want to have to do. I must have created a workgroup for all databases but how do I get rid of that?
#2 - I don't have a clue what the "target" or "start in" should be for the shortcuts on the employee's computers....so really all they are doing is opening up the shared database via a shortcut. The permissions prevent them from doing any serious damage, however, now only one person at a time can be in the database.
The 'help' function in Office is about as helpful as a hernia and the security wizard really doesn't do a very good job at explaining the steps in any detail in order to understand what's going on.
Quite frankly, I'm lost and if anyone out there has the patience to walk me through this I'd be much obliged!
All I want to do is take a new database that I've created, put the back end on the shared server and front end on each employee's individual computer so they can view reports and enter data. As Admin I need to be able to make changes to the database as needed. I've done this before with a prior database several years back but I can't remember how I did it nor can I find any notes I may have kept.
I've been tinkering around with the security wizard, user groups, permissions, etc and all I have created multiple problems.
#1 - Now whenever I open any Access database I am prompted for a logon which I don't want to have to do. I must have created a workgroup for all databases but how do I get rid of that?
#2 - I don't have a clue what the "target" or "start in" should be for the shortcuts on the employee's computers....so really all they are doing is opening up the shared database via a shortcut. The permissions prevent them from doing any serious damage, however, now only one person at a time can be in the database.
The 'help' function in Office is about as helpful as a hernia and the security wizard really doesn't do a very good job at explaining the steps in any detail in order to understand what's going on.
Quite frankly, I'm lost and if anyone out there has the patience to walk me through this I'd be much obliged!