[Samba] Serving MS Access Databases, with ACL

[Ellison, David]

Greetings,

This is a little off topic, but may be usefull to you. If the DB is
going to grow much more than that, I would use a real SQL backend to the
database. The MS Access DB backend is ok, however starts to suffer when
they become huge, by the sounds of things they may. I am sure there are
people with 700mb, 900mb etc Access databases, but its best to split the
front end from the database and use a SQL database like MySQl for the
backend.

Just food for thought :)

Cheers.
Dave

> -----Original Message-----
> From: 
> samba-bounces+david.ellison=atkinsglobal.com at lists.samba.org 
> [mailto:samba-bounces+david.ellison=atkinsglobal.com at lists.sam
ba.org] On Behalf Of jayendren anand maduray
> Sent: 31 October 2007 14:04
> To: samba at lists.samba.org
> Subject: [Samba] Serving MS Access Databases, with ACL
> 
> Hi All.
> Greetings from South Africa.
> 
> I have a Samba LDAP server (v 3.022) running on Ubuntu 6.10 
> Its serving about 200 users, with profiles, and domain logons.
> 
> I want to start server MS Access Databases on it, with the  
> best speed performance as possible.
> At the moment, the back ends for these databases, are about 
> 200+ MB, and will grow over the next few years.
> 
> Basically, the share should serve about 4 users, with 
> read/write access.
> I am using the XFS file system, with ACL support.
> 
> Has anyone setup such shares in smb.conf?
> I would really like to see an example.
> 
> Lastly, I do not think I want to use oplocks.
> 
> Any help, will be greatly appreciated.
> 
> God bless.
> 
> --
> Jayendren Anand Maduray
> Microsoft Certified Professional
> Network Plus
> Senior IT Administrator
> 
> Perinatal HIV Research Unit
> Wits Health Consortium
> University of the Witwatersrand
> 
> Alternate email address: jayendren at mweb.co.za Fax Number: 0866857317
> 
> ...There are 10 types of people,
> those who understand binary
> and those who do not...
> 
> --
> To unsubscribe from this list go to the following URL and read the
> instructions:  https://lists.samba.org/mailman/listinfo/samba
> 
> 
> This message has been scanned for viruses by MailControl - 
> (see http://bluepages.wsatkins.co.uk/?6875772)
> 


This email and any attached files are confidential and copyright protected. If you are not the addressee, any dissemination of this communication is strictly prohibited. Unless otherwise expressly agreed in writing, nothing stated in this communication shall be legally binding.

The ultimate parent company of the Atkins Group is WS Atkins plc.  Registered in England No. 1885586.  Registered Office Woodcote Grove, Ashley Road, Epsom, Surrey KT18 5BW.

Consider the environment. Please don't print this e-mail unless you really need to.