Add new comment
Samba: Working Around QuickBooks 2006 IncompatabilityPLEASE NOTE: This HowTo does not address multi-user mode. If multi-user mode is essential to you, I'm sorry I wasted this much of your time, but please don't let me take up any more. This HowTo addresses the incompatability that QuickBooks 2006 has with Samba-based file-sharing (the Linux de-facto standard for domain control and file sharing). Summary: Create a new user, group and share. Access the QuickBooks files via the new user by logging onto the share with its credentials. System: Symptoms: After upgrading to QuickBooks Premier 2006, User A opens the QuickBooks file for Company XYZ, and gets access. User B tries to open the QuickBooks file for Company XYZ and finds that the program seems to stall for 15 to 30 seconds, then receives a non-helpful error message that may eventually lead to a web page where Intuit states they don't support Samba file sharing. If User B opens the file first, the situation is reversed. Research (Net): I'm fairly good at researching problems on the internet, but I couldn't find one post that made it sound like it was even possible to get this type of setup working. (Thus I'm writing my first HowTo - be gentle folks, I'm just trying to give back.) Research (Server): Checked QuickBooks data files and found that they were owned by the linux/samba user who first opened the file (this gave me my first glimmer of hope). Preparation:
Result: False Starts: Tried to use Run As to run the .exe as the quickbooks user: didn't have access to network drives after program start and generally played havoc with my domain log-on. Possible Alternative: Use a native Linux mechanism to change ownership of files when they are needed (ie. bash script) Determination: QuickBooks uses a file-locking mechanism that is not compatable with Samba because it involves changing file ownership. Shame on you, Intuit. Complicating Factors: Providing multi-user access does not seem possible at this time, since it depends on the server to cooperate. Mitigating Factors: Disclaimer: This worked for me, but it could erase all your data and expose your deepest, darkest secrets to your mother-in-law. I'm just trying to help. Thanks to: The Mandriva folks and Altoid, who got me started in Linux; the Samba folks for a very solid product; the Webmin folks for making my life easy; all the contributors who make using Linux a possibility; the folks at Winders for keeping me in business :)
Reply |






Recent comments
2 hours 4 min ago
3 hours 52 min ago
4 hours 5 min ago
5 hours 17 min ago
6 hours 39 min ago
14 hours 32 min ago
19 hours 59 min ago
21 hours 55 sec ago
21 hours 47 min ago
23 hours 53 min ago