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 [EMAIL PROTECTED] 888-999-2574 x124 -----Original Message----- From: Markus Espenhain [mailto:[EMAIL PROTECTED]] 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: [EMAIL PROTECTED] -- To unsubscribe from this list go to the following URL and read the instructions: http://lists.samba.org/mailman/listinfo/samba