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@mail.applog.com
888-999-2574 x124
-----Original Message-----
From: Markus Espenhain [mailto:espenhain@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@etes.de