Re: MS Access - This Recordset is not updateable

2001-02-13 Thread Miguel Angel Solórzano

At 10:34 12/02/2001 -0700, John Halladay wrote:
Hi!

Generally your problem happened when you did the linking of the
MySQL table, Access didn't find a primary key column and you
didn't select any.
If the above is right, add a primary key column and link the
table again.

Regards,
Miguel
>I've scanned past e-mails and haven't found this in the archives.  This is
>probably something simple that I'm overlooking.
>
>If I'm connecting to a table in MySQL from MS Access 97 and getting the
>message "This Recordset is not updateable" whenever I try and change
>anything, where can I change the setting so I can read/write and not just
>read?  I also have another table that lets me make changes, but won't let me
>save them.
>
>Thanks,
>John Halladay
>
>-
>Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail 
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

__  ___   __
   /  |/  /_ __/ __/ __ \/ /   http://www.mysql.com/
  / /|_/ / // /\ \/ /_/ / /__  Miguel Solórzano <[EMAIL PROTECTED]>
/_/  /_/\_, /___/\___\_\___/  São Paulo, Brazil
<___/  Development Team


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




MS Access - This Recordset is not updateable

2001-02-12 Thread John Halladay

I've scanned past e-mails and haven't found this in the archives.  This is
probably something simple that I'm overlooking.

If I'm connecting to a table in MySQL from MS Access 97 and getting the
message "This Recordset is not updateable" whenever I try and change
anything, where can I change the setting so I can read/write and not just
read?  I also have another table that lets me make changes, but won't let me
save them.

Thanks,
John Halladay

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php