I have a question. My DB's are on a network, and there have been times when one of my users will open up one of my dB's and my code won't work all of a sudden. I get the call and go to fix it and it works fine on my machine. So I go to their machine and it won't recognize something like
"Dim dbs as Database
Set dbs = CurrentdB"
It's their references. I take a look and the references list has only 3 choices selected. So I re-add references and then it all works.
I know I'm the only person that knows how to get in there, so no one else is changing them manually.
There are also times when the references lists are shortened on my PC as well. Do references follow the DB or stay with the PC? Is there a way to "lock" them in so I don't have this issue any more? Could a network refresh or back-up be interfereing with my dB?
Any help on this would be greatly appreciated.
Thanks,
Kyle
:
"Dim dbs as Database
Set dbs = CurrentdB"
It's their references. I take a look and the references list has only 3 choices selected. So I re-add references and then it all works.
I know I'm the only person that knows how to get in there, so no one else is changing them manually.
There are also times when the references lists are shortened on my PC as well. Do references follow the DB or stay with the PC? Is there a way to "lock" them in so I don't have this issue any more? Could a network refresh or back-up be interfereing with my dB?
Any help on this would be greatly appreciated.
Thanks,
Kyle
:
