Topic: Record locking for MS Access

[Martin Trigg]

I need to host the database for a multi-user Accounting package on an SME5 server.

The package uses a Microsoft Access database. The Software supplier has indicated the following is required:
The Database must operate within a "Windows Server Emulator environment" with "Preferential Record Locking parameters" correctly set.

In searching the Forum and Web I can find no definitive answer as to whether SAMBA supports "Win 2000 Server" record locking functions and thus an Access database.

I would be grateful if some one with experience in this area could point me in the right direction.

Regards
Martin
      ---    __o   
     ---   _-\<,_    
      --- (_)/ (_)

[Alexander Ziemann]

Access has serious problems with several file-locking options, that are enabled by default in samba. This concerns file caching and file locking.

You should search the newsgroups (e.g. os.comp.protocol.smb) by google with keywords "samba access locking" and you will find the appropriate options you have to set.

hth

Alex