Running VBA even when a database opens in protected view

[drmannete]

I new to VBA. I wrote a code in open event of a form to track all the users entering a database. For this I made a form which creates a new record as soon as I open the database and logs it in a table. I used an Autoexec macro to open the form on opening the database. The database is in a shared network drive. It works perfectly when I try it, but when someone else tries it for the first time, it opens in protected mode and does not create a new record. When they enable content, it works fine later.

We don’t want people to be able to enter the database without their name logged. Can I do anything to run the Macro or open the form even when the file is in protected mode? Or anything else I can do? Please suggest.

I am using Access 2010.



Thanks!

[redbull]

You are going to want to look at splitting the database, with a backend and front end. The front end will ultimately be housed on each PC, while the backend remains on the network share, and it is where all the data is stored. This will resolve the problems of multiple users accessing the same file. I will find a forum link that is given out frequently around here and post it.

[drmannete]

The link would be great. Thanks for the reply!