AutoExec Macro in Access 2010

[AlexCS]

Hi everyone,

Do you know if it is possible to run an AutoExec macro to open a database in read only mode if the username is different than the Admin's username? Please let me know your ideas, I am really new to Access and I wanted to avoid creating a form if possible.

Many thanks!

Alex

 

[xenou]

Can you clarify what you mean by "read only". What do you want to restrict?

 

[AlexCS]

Can you clarify what you mean by "read only". What do you want to restrict?

Hi Xenou and thanks for your time! I would like to only allow the users to see and filter the data, but not to delete or change it.

Cheers, Alex

 

[xenou]

Hi, I think then that you want to use forms in datasheet view as your tables and/or queries. Forms can be set so that you disallow edits and deletes. A savvy and motivated user could get around that pretty easily, if they were so inclined, so it really just stops people from making changes inadvertently or without thinking about it. If you need higher security you can work with database privileges on a user level (this is a bit of work and I personally have very little experience with it, so I can't help with that).

I guess in principle you could play around with ACL to make the file read-only to most users, and give write access to yourself but I don't know if that would actually work or not (would be interesting to find out). I've never done anything like that either so no personal experience on this front either.

ξ

 

[AlexCS]

Thank you for your suggestions Xenou ..I have tried a few things but everything is either too complicated or does not suit the purpose. In the end I believe I will try to password protect the database and allow users to see the Access data only via query results written directly to Excel. I will post the solution for future reference as soon as I find one.

Have a good day!
Alex