MySQLTalk.org MYSQL discussions groups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Problems with Access 97          MySQLTalk.org Forum Index -> MySQL ODBC View previous topic :: View next topic   Author Message Juergen Hoffmann Guest Posted: Fri Jul 23, 1999 1:09 pm    Post subject: Problems with Access 97 Hello, I know some of you might think it is a stupid question, but I have a problem with MS Access 97 and Mysql on Debian Linux 3.21.xx If I try to insert or update data in some records Windows prompts with the Error message, that some other user is currently working in this record, although I am the only one connected to the server??? kind regards Juergen Hoffmann -- Mit freundlichen Gruessen Juergen Hoffmann ------------------------------------------------------------------------------- my quote of the day: Peace, n.: In international affairs, a period of cheating between two periods of fighting. -- Ambrose Bierce, "The Devil's Dictionary" Back to top Patrick Sherrill Guest Posted: Fri Jul 23, 1999 2:25 pm    Post subject: Re: Problems with Access 97 Make sure you have a TIMESTAMP(14) and a PRIMARY KEY in the table. Pat... ----- Original Message ----- From: Juergen Hoffmann <jh (AT) luenecom (DOT) de> To: <myodbc (AT) lists (DOT) mysql.com> Sent: Friday, July 23, 1999 9:09 AM Subject: Problems with Access 97 Quote: Hello, I know some of you might think it is a stupid question, but I have a problem with MS Access 97 and Mysql on Debian Linux 3.21.xx If I try to insert or update data in some records Windows prompts with the Error message, that some other user is currently working in this record, although I am the only one connected to the server??? kind regards Juergen Hoffmann -- Mit freundlichen Gruessen Juergen Hoffmann -------------------------------------------------------------------------- ----- my quote of the day: Peace, n.: In international affairs, a period of cheating between two periods of fighting. -- Ambrose Bierce, "The Devil's Dictionary" --------------------------------------------------------------------- Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail [email]myodbc-thread460 (AT) lists (DOT) mysql.com[/email] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [email]myodbc-unsubscribe (AT) lists (DOT) mysql.com[/email] instead. Back to top Juergen Hoffmann Guest Posted: Fri Jul 23, 1999 6:08 pm    Post subject: Re: Problems with Access 97 On Fri, Jul 23, 1999 at 10:25:27AM -0400, Patrick Sherrill wrote: Quote: Make sure you have a TIMESTAMP(14) and a PRIMARY KEY in the table. Pat... Hello, I know some of you might think it is a stupid question, but I have a problem with MS Access 97 and Mysql on Debian Linux 3.21.xx If I try to insert or update data in some records Windows prompts with the Error message, that some other user is currently working in this record, although I am the only one connected to the server??? It concerns a field of the type DATE and a primary key is set. The TIME Field in the same record is writable to... :-( kind regards -- Mit freundlichen Gruessen Juergen Hoffmann -- my quote of the day: TeX is potentially the most significant invention in typesetting in this century. It introduces a standard language for computer typography, and in terms of importance could rank near the introduction of the Gutenberg press. -- Gordon Bell Back to top David Carlson Guest Posted: Fri Jul 23, 1999 6:20 pm    Post subject: RE: Problems with Access 97 Hi Juergen As Pat suggested, please add a Timestamp(14) field to your tables (even if you feel you do not need a timestamp, or if you already have a date field in the table). For some reason, Access/ ODBC requires it. David -----Original Message----- From: Juergen Hoffmann [mailto:jh (AT) luenecom (DOT) de] Sent: Friday, July 23, 1999 11:09 AM To: Patrick Sherrill Cc: Juergen Hoffmann; [email]myodbc (AT) lists (DOT) mysql.com[/email] Subject: Re: Problems with Access 97 On Fri, Jul 23, 1999 at 10:25:27AM -0400, Patrick Sherrill wrote: Quote: Make sure you have a TIMESTAMP(14) and a PRIMARY KEY in the table. Pat... Hello, I know some of you might think it is a stupid question, but I have a problem with MS Access 97 and Mysql on Debian Linux 3.21.xx If I try to insert or update data in some records Windows prompts with the Error message, that some other user is currently working in this record, although I am the only one connected to the server??? It concerns a field of the type DATE and a primary key is set. The TIME Field in the same record is writable to... :-( kind regards -- Mit freundlichen Gruessen Juergen Hoffmann -- my quote of the day: TeX is potentially the most significant invention in typesetting in this century. It introduces a standard language for computer typography, and in terms of importance could rank near the introduction of the Gutenberg press. -- Gordon Bell --------------------------------------------------------------------- Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail [email]myodbc-thread462 (AT) lists (DOT) mysql.com[/email] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [email]myodbc-unsubscribe (AT) lists (DOT) mysql.com[/email] instead. Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         MySQLTalk.org Forum Index -> MySQL ODBC All times are GMT Page 1 of 1   Jump to: Select a forum MySQL----------------MySQL and JavaMySQL AnnouncementsMySQL++MySQL and .NETMySQL ODBCMySQL and PerlDatabase BenchmarksMySQL BugsMySQL Cluster DiscussionMySQL CommunityMySQL DocumentationEventum DevelopmentEventum General DiscussionMySQL General DiscussionMySQL GUI ToolsMySQL InternalsMySQL CommitsMaxDBMySQL PackagersMySQL Replication DiscussionBrisbane MySQL Users GroupMySQL on Win32  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.