Upgrading to 2002

[Brian P]

I'm trying to upgrade an access 97 application to 2002.

For the most part it all works, but there is a drop down box that is giving
me troubles.

When I (or a user) clicks on an item in the drop down box, there is an error:

3167 - Record is deleted.



In the code for the AfterUpdate event, their is a save:

"DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70"

Which seems to be causing the "deleted" error. If I comment out the save,
then you can click on an item, but if you leave that subform and come back
to it (the subforms are in a tab control) then it says #deleted in all of
the other fields.)


What is causing this deleted? I saw an article on MSDN about #deleted with
oracle databases (which this form is linked to an oracle database) but i
tried to update my jet drivers and it says i'm already on the latest.

Any ideas?

 

[Baz]

I'm trying to upgrade an access 97 application to 2002.

For the most part it all works, but there is a drop down box that is giving
me troubles.

When I (or a user) clicks on an item in the drop down box, there is an error:

3167 - Record is deleted.



In the code for the AfterUpdate event, their is a save:

"DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70"

Which seems to be causing the "deleted" error. If I comment out the save,
then you can click on an item, but if you leave that subform and come back
to it (the subforms are in a tab control) then it says #deleted in all of
the other fields.)


What is causing this deleted? I saw an article on MSDN about #deleted with
oracle databases (which this form is linked to an oracle database) but i
tried to update my jet drivers and it says i'm already on the latest.

Any ideas?

Have you tried refreshing all the links?