Latest LQ Deal: Linux Power User Bundle
Go Back > Forums > Linux Forums > Linux - Server
User Name
Linux - Server This forum is for the discussion of Linux Software used in a server related context.


  Search this Thread
Old 02-26-2008, 09:39 AM   #1
LQ Newbie
Registered: Sep 2003
Posts: 3

Rep: Reputation: 0
Samba 3, MS Access mdb files failures

Using Samba 3.0.23 on a Slackware 10.2 box, Im facing failures on a share which hosts an MS Access database.

After some time around 3 to 10 minutes using (with no problems) a Visual Basic application which uses the Access database, it fails with a run-time error 2147217865(80040e37), saying that MS Jet engine is not able to find the database or a table. The share itself, however, is still working nicely at this point, I can reach the .mdb and .ldb files from this machine.

I tried many combinations of locking schemas from Internet searches, with no success. My current [global] section of smb.conf follows:

guest account = guestuser
load printers = no
printcap name = /etc/printcap
printing =
log file = /var/log/samba/%m
max xmit = 16384
max connections = 100
max open files = 100000
max log size = 100
deadtime = 10
keepalive = 60
read raw = no
write raw = no
getwd cache = yes
dos filemode = yes
dos filetimes = yes
dos filetime resolution = yes
encrypt passwords = yes
case sensitive = no
default case = lower
preserve case = yes
short preserve case = no
dos charset = ISO8859-1
unix charset = UTF-8
display charset = UTF-8
defer sharing violations = true
fake oplocks = no
kernel oplocks = yes
level2 oplocks = yes
oplock break wait time = 0
oplock contention limit = 2
oplocks = yes
veto oplock files = /*.mdb/*.MDB/*.ldb/*.LDB/
posix locking = yes
blocking locks = yes
lock spin count = 30

The share is using 777 permissions on the filesystem, to be sure that Access have no problems to create its lock files (.ldbs).

If someone faced this kind of problem before and could help me on this, It will be greatly appreciated.

Thanks in advance,
Old 03-27-2008, 01:38 AM   #2
LQ Newbie
Registered: Mar 2008
Posts: 1

Rep: Reputation: 0
Hi Norman,

i have a problem that seems to be the same, at least, the error code is exactly the same: "2147467259" and seems to be about file locking, althought also it tries to use a file "mswinsck.ocx" that doesn't exist in the share (i think it should exist) so i will to do some tests after tomorrow, here leave you some changes i'm going to do about the file locking in my smb.conf:

For the global section:

locking = yes
share modes = yes
oplocks = yes

For the share:
create mask = 0777
directory mask = 0777

I hope some of that options could help you to solve the problem, but also if you get the solution before, it will be greatly appreciated too...

Thanks and we are in contact...



access, samba

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access (mdb) file reader? logosys Linux - Software 2 08-31-2005 03:33 PM
password failures on samba access DaddyBad Linux - Newbie 5 09-08-2004 03:34 AM
Samba / XP login failures while tring to access shared files (works with win2k) Zero-0-Effect General 2 01-24-2004 10:27 PM
NFS and MS Access MDB Files ja_nch Linux - Networking 1 09-20-2003 02:53 PM
convert text File to Access MDB Corinne Linux - Software 2 09-24-2002 06:42 AM > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 08:31 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration