Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: Patrick F. Ducharme on August 19, 2003, 12:16:26 AM

Title: Samba and Access
Post by: Patrick F. Ducharme 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.

Title: Re: Samba and Access
Post by: bud 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).

Title: Re: Samba and Access
Post by: David Farrick 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.

Title: Re: Samba and Access
Post by: Patrick F. Ducharme 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 !

Title: Re: Samba and Access
Post by: David Farrick 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

Title: Re: Samba and Access
Post by: Patrick F. Ducharme 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.

Title: Re: Samba and Access
Post by: Michael Smith on August 20, 2003, 09:42:46 PM

The updates are cumulative.  Apply the most recent and you'll get 'em all.

Title: Re: Samba and Access
Post by: Patrick F. Ducharme 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

Title: Re: Samba and Access
Post by: Paul 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