P
Pele
I have put together an application in Access and we are
now going to be sending it out to the field for our
customers to use. I need to prevent changes to the design
of this tool and prevent users from seeing the code behind
the tool. But whatever security solution I implement,
should allow macros in the tool to be able to select,
delete and copy tables.
I tried to use the Security Wizard in Access 2000 but I
don't think I understood that enough. I then went and
created Users. I created one User (TACADMIN) and put him
in the Admins group and I created another User (TACUSER)
and put him in the User group. They both have seperate
passwords.
The problem is that Access still keeps on logging me on
under the default Admin User name since I was the one that
created the database. I'd assumed that Access will give me
a choice as to which of these 3 available users I wanted
to log in on but it doesn't.
Can somebody help me. I have a clean copy of the
application and I try any suggestion on a copy of that.
Pele
now going to be sending it out to the field for our
customers to use. I need to prevent changes to the design
of this tool and prevent users from seeing the code behind
the tool. But whatever security solution I implement,
should allow macros in the tool to be able to select,
delete and copy tables.
I tried to use the Security Wizard in Access 2000 but I
don't think I understood that enough. I then went and
created Users. I created one User (TACADMIN) and put him
in the Admins group and I created another User (TACUSER)
and put him in the User group. They both have seperate
passwords.
The problem is that Access still keeps on logging me on
under the default Admin User name since I was the one that
created the database. I'd assumed that Access will give me
a choice as to which of these 3 available users I wanted
to log in on but it doesn't.
Can somebody help me. I have a clean copy of the
application and I try any suggestion on a copy of that.
Pele