using access with mysql - common error

  • Thread starter Thread starter Andy Levy
  • Start date Start date
A

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
 
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...
 
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 ?
Click to expand...

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..
 
Back
Top