Users

[khurram7x]

How could I make user accounts in Access 2010 so that every user has different level of access??

I've seen in sample Access database I'm provided that it is asking for username/password before opening the database file. I'm also required to do so at work.

Thanks in advance.

 

[JHB]

Below is some info about you question.
https://support.office.com/en-za/ar...security-828a8be1-a9cd-463c-a07f-22d5abf78659

 

[Trevor G]

You more than likely will need some VBA. Has the database currently got any security levels in place as 2010 no longer uses the Security Wizard for groups and permissions.

 

[khurram7x]

You more than likely will need some VBA. Has the database currently got any security levels in place as 2010 no longer uses the Security Wizard for groups and permissions.

There are not security levels at place except default Windows security features on folders.
I've got a sample Access file from inside the company and it asks for username/password when you open the database. How could achieve so please??

 

[gemma-the-husky]

can you not examine the work sample to see how it was achieved. it would be better within a company to adhere to a standard framework, I would have thought.

 

[khurram7x]

can you not examine the work sample to see how it was achieved. it would be better within a company to adhere to a standard framework, I would have thought.

Actually company purchased this system for a specific project and i tried to open it, but it is in .accde format and Shift key hasn't helpled.
Is there a workaround please? What does generally a developer do to create an access system for MS Access please?

 

[Trevor G]

If your company has purchased this from another company/developer perhaps consider contacting them. If your company has purchased the write to alter the database there would be another copy as accdb somewhere.

I wouldn't like to continued to get involved now. Sorry