updating mySQL from access

[bob_man_uk]

i have a page that lists all the items in a mysql database no problem but when I want it to add on it just comes up #deleted in all the rows, any ideas why,

thanks

Mattyg

 

[SydneyGeek]

Don't know for sure because I haven't worked with mySQL, but #Deleted in a form is a sign of corruption in your Access database. Try running the Repair and Compact utilities (Tools | Database Utilities). Depending on your version of Access, they will be 2 separate items (97) or one item (later versions).

Denis

 

[bob_man_uk]

ok done the repair and compact and the data is actually in there (the mySQL database i mean) even viewing in a page/table is ok but when updating or making a new record it just says (not all the time mind) #deleted, is there a certain character it doesnt like or maybe its related to the datatype and what data is input.

if you come up with any ideas let me know, i think i got it cracked,

cheers

mattyG