Can't find referenced library database, INTERMITTENTLY

[DataMinerHome]

I have Access databases that have been running fine for years, unchanged. They all reference a common "library.accde" database which contains many commonly used functions. Recently, we've intermittently been experiencing that the databases cannot find any of the functions in the referenced library.accde.

For example, the autoexec contains 2 functions:
Livecheck()
DBUnavailable()
Both of these reside in the referenced library.accde

When I open the database, I get "The expression you entered has a function name that DB cannot find", followed by and "Action failed" dialog showing that livecheck() failed. If I delete livecheck from the autoexec, then DBUnavailable fails. If I delete the autoexec completely, other functions in the library db fail.

Again, this happens only intermittently. So far, it seems to happen only when we're running on a Citrix server, and may be server dependent. I have had one report of it happening outside of Citrix but have been unable to confirm.

Running Access 2007. Yes, it's a split database.

Any ideas?

 

[gemma-the-husky]

maybe the database cannot see the accde library at all, in some cases.

How do you reference the library. is it an absolute folder reference or are you using a mapped drive? in that case, maybe the mapping drive letter has changed?

 

[DataMinerHome]

I added the reference by browsing to a mapped drive. However, when I ask Access for the path to the reference it returns something like
\\global\tektronix\net\global\namerica\.....\MyLibrary.accde
So I assume this is the absolute reference.
Thinking that maybe this shows up differently on different servers, I added a button to my db to return the path....(has to be a button because the Citrix servers only have runtime Access). I turned off my autoexec so the db doesn't crash on open, and tried clicking the new button to see what the library path would show. But, now, on some of the Citrix servers, NONE of my buttons work!!!!!

So now I am suspicious that it's some sort of "Trusted locations" issue, keeping any of my code from running. But of course I can't set, or even view, the trusted locations from runtime. I know how to set trusted locations using a script, outside of Access, but of course I don't have the necessary permissions to do this on the Citrix servers.

 

[gemma-the-husky]

I thought maybe if you had set up the reference as, say x:\lib.accde, and some users had the mapped drive defined as Y: instead - that might be the cause of the problem.

 

[jleach]

For the record, a few years back I really wanted to implement library databases for re-usable code. After hours upon hours (over a week I spent extensively testing and bothering other members of my usual forum), I finally gave up and decided I'd just keep a text master and import into each new db I created.

My experience with library databases is that they are buggy, fickle and have a tendancy to cause problems for no apparent reasons whatsoever.

FWIW...

cheers,