Koozali.org: home of the SME Server

Samba and Access

Patrick F. Ducharme

Samba and Access
« on: August 19, 2003, 12:16:26 AM »
Hi,

I have a database wich is in reality a .mdb file that is store in a ibays called "bdadmin".  I can use it, work with it.  But, I have a problem, randomely, all the PC on the LAN are disconnected from the database, for about 1 sec. which cause a "Disk Error or Network Error" message in M$ Access.  

The solution I found was to quit access and restart it, but 2-3-4 times by day, it's verry annoying for our user.  I want a permanant solution !!

Anyone can help me ?

Thank you !!  Ask what you want (log, etc) if you need it.

Patrick D.

bud

Re: Samba and Access
« Reply #1 on: August 19, 2003, 02:45:43 AM »
And what sme version are you using?  Have you installed any additional RPMS?  What do your logs say?  (/var/log/samba).

David Farrick

Re: Samba and Access
« Reply #2 on: August 19, 2003, 02:46:43 AM »
I have previously monitored the Samba listserves and this issue has come up frequently.  Sorry I can't give you an answer here, but you may want to search the listserves and/or www.samba.org.

Patrick F. Ducharme

Re: Samba and Access
« Reply #3 on: August 20, 2003, 12:30:02 AM »
I'm using a Stock SME 5.6.  I installed PDF Over LAN and that's it.  I looked into the samba list and fount nothing usefull !

David Farrick

Re: Samba and Access
« Reply #4 on: August 20, 2003, 04:19:33 AM »
Have you applied the latest updates to 5.6?  This is straight from the Samba 2.2.5 "What's New" txt file:

"22) Return NT_STATUS_OBJECT_NAME_NOT_FOUND for ENOENT.  This fixes the bug of running the Microsoft Access executable (msaccess.exe) and database files from a Samba share documented in the 2.2.4 release"

Dave

Patrick F. Ducharme

Re: Samba and Access
« Reply #5 on: August 20, 2003, 04:44:31 PM »
How can I know wich Update is apply ??  I remember to have install an Update, but... do not remember which one...

Thank you.

Michael Smith

Re: Samba and Access
« Reply #6 on: August 20, 2003, 09:42:46 PM »
The updates are cumulative.  Apply the most recent and you'll get 'em all.

Patrick F. Ducharme

Re: Samba and Access
« Reply #7 on: August 20, 2003, 09:44:35 PM »
Where to get it since ftp.e-smith.org doesnt work ?  maybe the FTP is down...

Thank you

Paul

Re: Samba and Access
« Reply #8 on: August 21, 2003, 06:37:58 AM »
You must install this latest update for Samba to work correctly with Access (and other windows programs).  Go here and retreive it:

ftp://ftp.ibiblio.org/pub/linux/distributions/e-smith/updates/5.6/Update4/RPMS/

Good Luck

Paul