Hi everyone, If I add a MaxDB table to an Access2003 mdb as linked Table and open the Datagrid for direct input everything works fine up to the point where I want to change some data :o).
I get a "write conflict" message, although I'm definitely the only user on that maxDB test database. SQL trace log gives no hint: If I change the logs output file while I have the linked table open and before any changes, no further logging happens, when I change same data. So I don't even know what Access tries to do, when giving me the "write conflict message", probably some record locking. Config: Server: MaxDB 7.05.00.08 Database (Unix) on Debian linux. Client: Windows XP 2003 SP2 (the same behaviour on SP1) Access2003 ODBC-Driver 7.05.00.07 from 20.11.2003 (sqlod32.dll) To be more exact: ODBC VERSION : 7.5.0, BUILD: 007-113-057-319, which is the newest ODBC-driver I found. ODBC settings: INTERNAL Uncommitted I also tested other isolation levels with no success, but uncommitted should make the least problems concerning locks. If I use the same DSN I can get a remote view working perfectly with MS Visual FoxPro 7/8, which is writing back changes via UPDATE-SQL with no problems. SQL queries themselves from Access are also unproblematic. Any hint on using linked tables in Access? With kind regards, Olaf Doschke -------------------------------- Setmics Schroetteringksweg 16 D-22085 Hamburg Tel. : +49 (040) 64 78 92 - 28 Fax : (040) 64 78 92 - 31 eMail: [EMAIL PROTECTED] Web : http://www.setmics.de -------------------------------- -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
