jforget1
asked on
Alert when opeining a DB
I have a database which is being phased out and moved to a new one. I can't shut it down completely as there are orders which are in process. What I need to do is add a popup alert when they open the db referring them to the new db for new orders. How do I add this functionality?
ASKER
Well I can't revoke the rights because there may be a pending order they need to access for the near future. I will eventually block their access once all pending orders are completed.
As to the postopen event, how do I do that for the opening of the database. I know where to add for the form level, but can it be done at the database level?
As to the postopen event, how do I do that for the opening of the database. I know where to add for the form level, but can it be done at the database level?
Yes, what I said: go to the Other section when in the Designer, open the Database Resources, there you will find the Database Script. Double-click it and go to the PostOpen event.
ASKER
I misunderstood what you were saying in the original post. I will try and add the code there.
ASKER
Is there a way to do a message box which would alert a user to the change and include a link to the new database I want to direct them to?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the help, I will give it a try with your tips.
- revoke their rights on the database
- send everybody a mail that they should use the new db
Ah, they are allowed to read documents. Makes sense.
In the Other section of the database design, you can enter some code in the PostOpen event for the database. Put a MsgBox in there.