[Samba] Strange Problem with Access

[Bill Moran]

Ruben Fagundo wrote:

>
>>
>> I set the following options up and I still seem to have the same 
>> problem.  Did I set the oplock setting correctly???
>

It looks right, as best as I can tell.

>> I get the following error message, exactly from the win95 machines:
>>
>> "The Microsoft database engine stopped the process because you or 
>> another user is attempting to change the same data at the same time." 
>

Could it (possibly) be some other problem with the Access file itself? 
(just speculating)

>>
>>
>> The pertinent setting in smb.conf are as follows:
>> ===================================
>> [global]
>>
>> veto oplock files = /*.mdb/*.MDB/
>>
>>  [public]
>>    locking = yes
>>    oplocks = yes
>>    veto oplock files = /*.dba/*.dbm/*.mdb/*.MDB/
>>    share modes = yes
>>    strict locking = no
>>    comment = Temporary file space
>>    path = /home/apps/public
>>    public = yes
>>    writeable = yes
>>    create mode = 0777
>>    directory mode = 0775
>

Doesn't Access use some other sort of file? .mde or something?
If you run "smbstatus" while Access is running, what kind of locks
does it show on the files?  Check that out to see if it's working, and if
you've got all the apropriate file patterns.
I would suggest two things (in order):
1. Try turning off oplocks altogether
2. Figure that I was wrong about the oplocks and look at other 
possibilities.

How much would it take to install MySQL and put the Access database there?
MySQL works great with Access through the MyODBC driver. (I know this is
changing lanes without signalling, but I just thought I'd throw it out 
there.)

-Bill