P
Paul M
I want to ensure that the user cannot enter a duplicate
entry of an company's name. I've done it using an ADO
connection then searching through each company name in
the Company table. This works fine but when I add share
level or user level security, I need the password to open
the ADO connection within the code. This is fine for me,
but not the users since I don't want them to access the
VBA and I don't want to put the onus on them.
Is there an easier way to check for duplicate entries so
that I can still password protect the database, allowing
the administrator to change this when deemed necessary. I
am sure there must be but I just can't sort this one out!
Any advice would be appreciated sincerely.
Regards
Paul M
entry of an company's name. I've done it using an ADO
connection then searching through each company name in
the Company table. This works fine but when I add share
level or user level security, I need the password to open
the ADO connection within the code. This is fine for me,
but not the users since I don't want them to access the
VBA and I don't want to put the onus on them.
Is there an easier way to check for duplicate entries so
that I can still password protect the database, allowing
the administrator to change this when deemed necessary. I
am sure there must be but I just can't sort this one out!
Any advice would be appreciated sincerely.
Regards
Paul M