using access with mysql - common error

[Andy Levy]

I have an Access frontend with a MySQL backend.

I am using a timestamp in MySQL to prevent the record from showing "deleted"
just after i insert it.However the "deleted stil occurs. The only way I
have found to prevent it from showing "deleted" is by changing all the TEXT
type fields in MySQL to varchar(50) fields.

Why is this happening . Is it a problem with access or MySQL.?


Thanks

Andy

 

[Albert D. Kallal]

Hum, I have not seen that behavour.

It has been a more then a year since I played with MySql..and perahps
somthing was changed (they had a lot of releases in the past year).

Last time I tried..I had no trouble...

 

[Andy Levy]

Do you know of any good mysql - access newsgroups ?

 

[Albert D. Kallal]

You already exposed the time stamp field..and I also assume that a key field
is exposed in the query.

In doing the above (as you also mentioned you did)..then I had no trouble
using MySql, and the "deleted" problem went away.

Do you know of any good mysql - access newsgroups ?

Hum...no, not off the top of my head.

I since left MySql since every office cd now has a free edition of sql
server on it (the desktop edition). In addition, you can also download the
incredible ms-sql server Enterprise tools for free, and use that with this
sql server engine (all at no cost). So, basically, you can get all of the
ms-sql server tools and database for free. This is really nice stuff, and
you get to learn/use and implement ms-sql server which not only is really
nice...but also very popular in terms of use by companies. Not a bad way to
get up to speed with sql server, and you get all the stuff like t-sql
(stored procedures, and triggers).

I just don't have MySql setup on my pc anymore, so I can only go on what
worked by my memory. Perhaps some of the mysql groups might help....sorry..