|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
May 8th, 2003, 01:58 AM
|
|||
|
|||
#Deleted while adding a record into ODBC (MySQL) table via Access
Hello.
I have an problem wich may not be a problem at all but don't know if this is normal. Recently, I started using MySQL server as my RDMS. Also, I use Access as my GUI for updating, editing ... data. But, I have one problem, when adding new record in Access GUI, the moment I have added it and jump to new empty record, the added record appeares #deleted on the GUI dialog. Any clues what? I use W2K Pro, MySQL 4.1.0 Alpha, Access 97. Thanks for any help.
|
|
#2
March 8th, 2004, 05:59 AM
|
|||
|
|||
|
Hi.
Did you ever get to the bottom of the #deleted problem in MS Access? I am getting it when I try to use auto-increment fields. (At the moment, I need to close the form and re-open it to view the new record - not v. practical) Any advice would be appreciated. Regards, MutantTrafficCo. Quote:
|
|
#3
February 27th, 2005, 08:00 AM
|
|||
|
|||
Got this problem as well.
I got around it by using the 'requery' function. I call this function on the After_Update event. Private Sub Form_AfterInsert() Requery End Sub It's not the most beautifull way but it works. Note: After a Requery the focus changes to the first record again. This was a problem for me and had to fix this by figuring out which field had the focus before I requery. Damaze
|
|
| Viewing: Dev Articles Community Forums > Databases > MySQL Development > #Deleted while adding a record into ODBC (MySQL) table via Access |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
