[Samba] Samba and MS Access Problems]

Tony Nichols tony at mail.applog.com
Mon Oct 14 21:23:01 GMT 2002

We have ms sql 2000 (our accounting software) so it was easy to export
directly to ms sql; then "import link" to bring the tables back in. No
data lost .... 

I have seen somewhere a module for MySql that will do it if your not
using ms sql .....
1. http://www.mdb2mysql.de/ free ...
2. http://www.dmsofttech.com/downloads.html this one looks very easy but
will only work 30 times before you have to buy it $35.00 US


A.G. (Tony) Nichols
I.S. Manager
Appalachian Log Structures Inc.
tony at mail.applog.com 
888-999-2574 x124

-----Original Message-----
From: Markus Espenhain [mailto:espenhain at etes.de] 
Sent: Monday, October 14, 2002 2:20 PM
To: Tony
Subject: RE: [Samba] Samba and MS Access Problems]

Hello Tony,

>> When one user makes changes to the database, the changes will not be 
>> seen on the other pcs until the database is closed an reopened. We 
>> made some tests with several samba options e.g. file locking, oplocks

>> and strict locking, also with "sync after writes" but nothing helped.

>> When we copy the database to a windows nt server, the problem 
>> disappears and everything works fine.

> Make sure under tools, options the default open mode is shared .... My

> problems had been op locks .... They all went away after I exported 
> the tables to a sql server then re-imported them as links.

I have read your thread because I have this Problem.
Gives it an way to export direct the tables and the content of the
tables or must I create the Tabeles manually?

Thnaks a lot.

cu Markus

Markus Espenhain                         Fon: +49 (7 11) 48 90 83 - 0
ETES - EDV-Systemhaus GbR                Fax: +49 (7 11) 48 90 83 - 50
Libanonstrasse 58 A * D-70184 Stuttgart  Web:   http://www.etes.de

Inflex - eMail Scanning and Protection
Queries to: postmaster at etes.de

More information about the samba mailing list