References - programmatically check correct refs when database opens

[Leonard Priestley]

Can someone point me in the direction of code that can be run when a
database opens, to check the necessary references are present? It would
help in distributing my database to other users.

Thanks
Leonard