[Samba] Samba and MS Access Problems]

[Tony Nichols]

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


tony

A.G. (Tony) Nichols
I.S. Manager
Appalachian Log Structures Inc.
www.applog.com 
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