emilybartholomew
Technical User
Hello-
I have a mysql database which I've linked to an Access db in ordre to create forms and reports for my users. I have this table (called funding) which has an auto-increment primary key (called f_id). It doesn't do anything other than uniquely identify each row. I am trying to write a routine that will delete a row out of the funding table based on this f_id. The weird thing is that when I open my recordset and loop through the values of "f_id" for the funding table, not only does it not show the most recent entries, it returns records which I have deleted manually from the table.
Table looks like this:
.
.
.
189
190
245
Returned values look like this:
.
.
.
189
190
191
192
193
Does anyone know why this is happening? I'm using myodbc 2.5, Access 2000, mysql 3.23 (I think) I've installed the most recent MDAC and MS Jet 4.0 service pack 5.
I have a mysql database which I've linked to an Access db in ordre to create forms and reports for my users. I have this table (called funding) which has an auto-increment primary key (called f_id). It doesn't do anything other than uniquely identify each row. I am trying to write a routine that will delete a row out of the funding table based on this f_id. The weird thing is that when I open my recordset and loop through the values of "f_id" for the funding table, not only does it not show the most recent entries, it returns records which I have deleted manually from the table.
Table looks like this:
.
.
.
189
190
245
Returned values look like this:
.
.
.
189
190
191
192
193
Does anyone know why this is happening? I'm using myodbc 2.5, Access 2000, mysql 3.23 (I think) I've installed the most recent MDAC and MS Jet 4.0 service pack 5.
