Database events

[jg2469]

I am looking for another way of having a database run code on startup other than using the autoexec macro. Is there an Open event for an Access database??? Please help!! Thanks!

 

[Mudface]

I'm not sure if there is. However, you can set which Form you want to appear when the database is opened through Tools-Startup, code written in the Load event of that form will then run on opening the database.

 

[jg2469]

I need to have everything done through code. I am making front end applications and would rather the startup procedure be executed through code only being that making a db into a mde only compiles code and leaves users the ability to edit macros and change startup options.

 

[Philem]

Hullo. Is this for an internal user base? If so, education is a step you cannot ignore. When I was producing applications for internal use, I gave a detailed training session, and let the users know that it works the way it was designed. If they decided to alter the design, not only would they be in violation of company policy, but they would be on their own.

Now, if this is for an external user base, I strongly recommend doing your front-end in some form of VB. That way, the users will have no options.

HTH

P

 

[jg2469]

It is internal and have no other means of making the application other than using Access. I suppose I will just have to makedo. Thank you for the suggestions!!!!

 

[Philem]

Hullo. Another thought: When you set up the db, BEFORE converting to an MDE, are you sure you are locking down everything you want? And, have you looking into Access security? If you secure the db, and don't give the users permissions to alter macros, modules, and what not, you should not have a problem.

Just another idea.

P

 

[jg2469]

I have tried that route but cannot really get how it works. Granted, I haven't looked into it with great detail, but when I had, I didn't really "catch on" to how to manage it. Currently each user that logs into the database is considered an admin. If you wish you can give me simpler instructions on setting this up. If not, I'll try and research it a little better. Thanks for your help once again!!