MS Access using MySQL

I have been trying to use MS Access 2000 as a front end to MySQL. Ok, I know I should be using java, but the client has said, no, we are using Access. Now I have successfully created a mysql db with some tables, specifically one called awards_tbl which has these columns:

id - int - autoincrement turned on
award - varchar(128)
awardDetails - TEXT
client - varchar(128)
timeofday - timestamp

Now, according to the manual, I had to put in the timestamp field in order to update this table. Now, I have successfully connected to this db via access and the Mysql ODBC driver. What I have seeing is that on the form for this table, I get a #deleted# text value in each of the form fields, when I add a new record using the form. But, when I view the actual data in the db, the data is correct. Ok, does anyone know how to get rid of the #deleted# from the form? What other things should I look out for in this setup? Thanks.

Ed cohen

I do a LOT of MySQL programming in Access, and my approach is to never, ever, under any circumstances even consider thinking about using "bound" controls for anything that's edited.

Instead, I use all "unbound" forms, then in my On_Current I call a "FillInForm()" or similar local function that reads the appropriate record into a DAO or ADO recordset, populates the form fields, then closes the query. When the user hits a "Save" button, I do an "UPDATE" query composed from the data in the fields.

It is a REAL pain to code all of it, but the results are really nice - especially being able to check fields and kick back error messages or set defaults as desired. And since I charge by the hour for programming....

I would like to use mysql backend to access front end . would one of you guys or some body tell me how to set up the odbc. Im using windows 2000

Pat