Can I subscribe to information on new tests?
MsAccess:
Hello Guest
  
  • Login
• Register…
• Start blog
  • Who, Where, When
• What is interesting here?
• Duels
  • Polls
• Avatars
• Interests
  • Cities and Countries
• Random blog
• Users search
  • Search
• Games
• Tests
• QAIX
  • Сообщества
• Talxy Chat
• Horoscope
• Online
 
Register!

QAIX > MySQL database development > MsAccess: "Write conflict......" 8 October 2003 04:18:17

  Top users: 
  Recent blog posts: 
  They have birthday today: 
  Forums:   
  Discuss: 
  Recent forum topics: 
  Recent forum comments:
  Модератор:

MsAccess: "Write conflict......"

Josй Miguel Serrano 6 October 2003 20:35:12
 
Hello all:

I hope your comprehension about my quite bad English. I have a problem
with mysql tables links into a MsAccess file. I describe that:

* Server: Red - Hat 9. MySQL Server 3.23.56
* Client : Win 2000 Prof. MySQL ODBC 3.51. Office 2000 Prof. MySQL
tables linked in a Access file.
* If tables does not have date, datetime or timestamp fields, it
hasn't problems. All at the moment is fine.
* If tables have date fields, then MsAccess appear a Dialog window,
explaining there is a "Write conflict. Another user has changed
data......" and I only can cancel. Never update records.

I 've tried to do some accions:

* Seach in FAQ's and I found this page
http://www.mysql.co­m/products/myodbc/fa­q_4.html#Write_confl­ict ,
but the explanition is empty ї?
* I've changed all the date kinds of fields.
* In the DSN, I've tried some options.
* ....

Any ideas?. Could someone help me?

Thanks in advance,



Josй Miguel Serrano


Add comment
Guest 8 October 2003 04:18:17 permanent link ]
 Does your table have a primary key? What type is the primary key?

John Bonnett

-----Original Message-----
From: JosГ© Miguel Serrano [mailto:jmserrano@ain.es]
Sent: Tuesday, 7 October 2003 3:05 AM
To: myodbc@lists.mysql.­com
Subject: MsAccess: "Write conflict......"



Hello all:

I hope your comprehension about my quite bad English. I have a problem
with mysql tables links into a MsAccess file. I describe that:

* Server: Red - Hat 9. MySQL Server 3.23.56
* Client : Win 2000 Prof. MySQL ODBC 3.51. Office 2000 Prof. MySQL
tables linked in a Access file.
* If tables does not have date, datetime or timestamp fields, it
hasn't problems. All at the moment is fine.
* If tables have date fields, then MsAccess appear a Dialog window,
explaining there is a "Write conflict. Another user has changed
data......" and I only can cancel. Never update records.

I 've tried to do some accions:

* Seach in FAQ's and I found this page
http://www.mysql.co­m/products/myodbc/fa­q_4.html#Write_confl­ict ,
but the explanition is empty Вї?
* I've changed all the date kinds of fields.
* In the DSN, I've tried some options.
* ....

Any ideas?. Could someone help me?

Thanks in advance,



JosГ© Miguel Serrano



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.­com/myodbc
To unsubscribe: http://lists.mysql.­com/myodbc?unsub=gcd­mo-myodbc@m.gmane.or­g


Add comment
 

Add new comment

As:
Login:  Password:  
 
 
  
 
Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или законы РФ. Ваш ip-адрес записывается.


QAIX > MySQL database development > MsAccess: "Write conflict......" 8 October 2003 04:18:17

see also:
replying to very old posts
Re: SLRN questions
Xnews 5.04.25 Binary Attachments
pass tests:
What is Your Temperament?
see also:
Halloween surprise-- Aiseesoft offers…
New iPod touch 2G Guide

  Copyright © 2001—2010 QAIX
Идея: Монашёв Михаил.
Авторами текстов, изображений и видео, размещённых на этой странице, являются пользователи сайта.
See Help and FAQ in the community support.qaix.com.
Write in the community about the bugs you have noticedbugs.qaix.com.
Write your offers and comments in the communities suggest.qaix.com.
Information for parents.
Пишите нам на .
If you would like to report an abuse of our service, such as a spam message, please .
Если Вы хотите пожаловаться на содержимое этой страницы, пожалуйста .