Emulating a table with a Autonumber Field w/Mysql ?

Emulating a table with a Autonumber Field w/Mysql ?

am 26.07.2006 19:27:18 von David Heller

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 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



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: Emulating a table with a Autonumber Field w/Mysql ?

am 27.07.2006 01:30:37 von jbonnett

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:daveh@goingtoheaven.net]=20
Sent: Thursday, 27 July 2006 2:57 AM
To: win32@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=20
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=20
programmer set up a form that does just that the form just points=20
to the last row of the table and you just type what you want in
the form and it saves it when a 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!!=20
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




--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org