2 messages in com.mysql.lists.win32RE: Emulating a table with a Autonum...
FromSent OnAttachments
David Heller26 Jul 2006 10:26 
jbon...@sola.com.au26 Jul 2006 16:30 
Subject:RE: Emulating a table with a Autonumber Field w/Mysql ?
From:jbon...@sola.com.au (jbon@sola.com.au)
Date:07/26/2006 04:30:14 PM
List:com.mysql.lists.win32

When I link a MySQL table in Access, I do get a blank row at the end, but I do have full access to that MySQL database.

It may be that Access thinks the table is read only, so no rows can be added. Are your MySQL permissions correct? You could check this by trying to make a query (append query or a pass thru query that does an INSERT) that tries to add a row to a MySQL table. If that fails with some sort of permission denied error you know that is your problem.

John Bonnett

-----Original Message----- From: David Heller [mailto:dav@goingtoheaven.net] Sent: Thursday, 27 July 2006 2:57 AM To: win@lists.mysql.com Subject: Emulating a table with a Autonumber Field w/Mysql ?

Hi

With VB tables that have an autonumber field you also have that last row available in Access. However using mysql there is never an "empty" row in your table. Is there any way to emulate this behavior with mysql?? The reason I ask as I'm trying to migrate an existing Access Application to use mysql in which the programmer set up a form that does just that the form just points to the last row of the table and you just type what you want in the form and it saves it when a <CR> is typed. However using mysql it won't work it only displays preexisting rows. I'm pretty sure it does not work because of the fact the "new" row does not exist yet!! I was thinking that it might be possible to create a temporary table in Access that would fetch all the prexisting rows into a new table in Access and then add the new rows as needed and then export them back to mysql but I have no idea how to implement that in VB as I'm more savy with mysql, Access I know little about.

Thanks,

Dave

ps If need be I can send the form on request