Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: Patrick Tehand on March 17, 2003, 03:56:52 AM

Title: Oplocks and MS Access
Post by: Patrick Tehand on March 17, 2003, 03:56:52 AM

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

Title: Re: Oplocks and MS Access
Post by: Jim Huneycutt on March 17, 2003, 04:07:38 AM

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

Title: Re: Oplocks and MS Access
Post by: Patrick Tehand on March 17, 2003, 04:57:51 AM

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

Title: Re: Oplocks and MS Access
Post by: Jim Huneycutt on March 17, 2003, 05:07:06 AM

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

jim

Title: Re: Oplocks and MS Access
Post by: rob Wellesley on March 17, 2003, 08:04:51 AM

remember to expand the template and restart samba :-)

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

Title: Re: Oplocks and MS Access
Post by: Dale Kuhlman on March 18, 2003, 02:20:53 AM

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

Title: Re: Oplocks and MS Access
Post by: Jim Huneycutt on March 18, 2003, 02:50:01 AM

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

Title: Re: Oplocks and MS Access
Post by: Steve Clifton on May 30, 2003, 09:03:09 PM

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