Topic: Oplocks and MS Access

[Patrick Tehand]

Hi all,
I have been having issues with opening MSAccess97 files on our SME5.6 server (along with some db accessing from an administration application we use)

Seems OPlocks and MS Access are mutually exclusive.

Hope this helps someone else.

Cheers
Patrick

[Jim Huneycutt]

Patrick,
Would you please tell me more about this situation? I am setting up a 5.6 server for a client whose major application is an older version of Access. I would appreciate any tips, gotchas or info in general. I thought 5.6 was more compatible with Access based on the Mitel info. Should I stick with 5.5?

(Btw, without pptp capability I am leaning towards using 5.5 for this site anyway - I have not figured out how to support the 5.6 servers remotely without a pptp connection. I now have three server installations on hold pending resolution of the pptp problem... ce la vie.)

Thanks,
jim

[Patrick Tehand]

Hi there Jim,

I found that any MSAccess97 .mdb files would report an error saying "cannot open file, cant get lock" or something like that when double clicking it.

You could open the file by opening Access then opening the file from within Access

I turned off oplocks and it now works fine.

To turn off oplocks just copy

/etc/e-smith/templates/etc/smb.conf/11kernelOplocks
/etc/e-smith/templates/etc/smb.conf/11level2Oplocks

to /etc/e-smith/templates-custom/etc/smb.conf/11kernelOplocks
and /etc/e-smith/templates-custom/etc/smb.conf/11level2Oplocks

and change oplocks = yes to oplocks = no

cheers

Patrick

[Jim Huneycutt]

Patrick,
Thanks - I will add this to the growing bag of tricks necessary to run eSmith with Windows clients.

jim

[rob Wellesley]

remember to expand the template and restart samba

/sbin/e-smith/expand-template /etc/smb.conf
/service smb restart

[Dale Kuhlman]

I am running Windows 2000 Professional, Access 2000, SME 5.1.2, and Samba 2.2.7-3.  I am having two file locking problems.  The first is that only one person can access the Design Master at a time even though I have set the Access database properties to allow multiple users. The Design Master is stored on the server running SME 5.1.2.  

The second problem is now occuring with my work around. I created a replica on the hard drive of a network user's computer and multiple users can access that database.  Until Friday, I was able to syncronize the Design Master and the replica. Now when I try to syncronize, I get an Access error message telling me that the Design Master can not be locked.

Both 11oplocks and 11level12oplocks is set to no; and I don't have an 11kerneloplocks file.

Can anyone suggest a fix for these problems.

Thanks,

Dale

[Jim Huneycutt]

Dale,
Here is a reference to some registry entries (Win2k and XP) that I am using for client sites where I want to make sure to turn off opportunistic locking.

http://support.microsoft.com/default.aspx?scid=kb;en-us;296264

Good luck,
jim

[Steve Clifton]

If you can get a copy of ACT there is an utility called actdiag.exe. This can be used to disable opportunistic locking on NT,XP,2000 machines without needing to hack the registry.

I have an SME server running ACT with 30 users utilising SMB. I have no problems with locking.

Regards

Steve