Novell and MS Access Database

[roni0401]

The .ldb file (sharing/locking) file that MS Access creates when a user logs into the databse is not allowing sharing. I flag it Shareable but the minute a second user goes in the flag changes to read only again. I get no specific error other than utiliztion shoots up to 75 %. I disconnect the user and have to run vrepair to get back to a good starting point.

All of the users have rights to the directory. Just out of frustration I made everyone a trustee with ADMIN equivalency. I still get the problem. The company that wrote the database has no answers.

I can set it up peer to peer no problem on a workstation but that presents it's own problems with having too many hands in the mix.

 

[TheLad]

Have you got file caching switched off on the server? Command at the console is:

SET FILE CACHING ENABLED = OFF

Have you also tried flagging the file as Transactional as well? What version of the NetWare Client are you using?

-----------------------------------------------------
"It's true, its damn true!"
-----------------------------------------------------

 

[roni0401]

Hi,

I am using v 4.83 for the client. The caching is turned off Access at the client stations do not have Exclusive chosen.

Still looking for an answer. I do so appreciate your response because it helps me rethink my steps.

 

[Jontmke]

We used to have a program that made those .ldb files. Isn't the program supposed to make one for each user? If not, can you get the program to write that file somewhere else? Like there user directory? That way they have there own.
Our problem used to be that the program created one for each user but left orphans all over the place.

Jon

There is much pleasure to be gained from useless knowledge. (Bertrand Russell)