'#deleted' problem...

  • Thread starter Thread starter Samball
  • Start date Start date
S

Samball

I have a problem which is bugging me for some time now...
I converted a MSAccess database to mySQL database.
Now when selecting from a combobox, (which is linked to a
table called [users]), a userId, i am doing a refresh in
the code , (DoCmd.DoMenuItem acFormBar, acRecordsMenu,
5, , acMenuVer70) , to write the data that came up when
selecting that userId to another table called [Problems].
Just after the refresh, it writes the data to the
[problems] table but the combobox and all the other Edit
Boxes which were filled with data from selecting a userId
now reads "#Deleted". Some where I lost the connection
with the data base I guess.
Anyone know where the problem might be?

Thanks...
 
Some where I lost the connection
with the data base I guess.
Anyone know where the problem might be?
Click to expand...

If this is all ODBC and ADO, then you may be better off trying one of the
ADO groups.

In your place, I think I would be doing all the data manipulation using
proper SQL calls and keeping track of the Connection objects -- using DoCmd
for managing data involves too much finger-crossing for my liking.

Sorry that's not a lot of help!

B Wishes


Tim F
 
Back
Top