mikelauwrie
Programmer
Hello all,
I hope you can help, as I'm a bit puzzled!
I have created a database (access 2000)(which is on a server) and secured it with the security wizard. This was before I knew anything about workgroups.
Through this securing process there was a workgroup file created in the same directory as the database (called secured). If I run wrkgadm.exe I find that I am using the 'system.mdw' standard workgroup. This I copied to the network directory of the database.
Now the security settings work on my computer - when I open the database a login box pops up and I can login in using any of the accounts that I created.
However if I try to login from another computer on the network I am not allowed to access the file (I don't get an option to login). It is worth noting that I changed the workgroup to the one that I copied from my computer onto the server.
This is my problem: if I disable the admin password, anyone can access the database without needing to login - no security. Or if I enable the admin password I can use the database I want to, but no one else can login - problem!
I hope someone can shed some light on this problem.
cheers
Mike
I hope you can help, as I'm a bit puzzled!
I have created a database (access 2000)(which is on a server) and secured it with the security wizard. This was before I knew anything about workgroups.
Through this securing process there was a workgroup file created in the same directory as the database (called secured). If I run wrkgadm.exe I find that I am using the 'system.mdw' standard workgroup. This I copied to the network directory of the database.
Now the security settings work on my computer - when I open the database a login box pops up and I can login in using any of the accounts that I created.
However if I try to login from another computer on the network I am not allowed to access the file (I don't get an option to login). It is worth noting that I changed the workgroup to the one that I copied from my computer onto the server.
This is my problem: if I disable the admin password, anyone can access the database without needing to login - no security. Or if I enable the admin password I can use the database I want to, but no one else can login - problem!
I hope someone can shed some light on this problem.
cheers
Mike