Access + Mysql = prob

A

Andre Comeau

Hello,

I've linked some mysql table on My Access DB. When I add/update some
data, My form is not updated so I see "#Deleted" in every field. But
when I Reload my form (close and reopen it) All my data are saved. When
can I do to make it more userfriendly.

I have also noticed that the field and receord validation is not in
operation. Could you help with that too. Of cours I could do validation
in VBA but if there's an easiest way...

Thanks a lot

Andrew
 
L

Larry Linson

I've linked some mysql table on My
Access DB. When I add/update some
data, My form is not updated so I see
"#Deleted" in every field. But when I
Reload my form (close and reopen it)
All my data are saved. When
can I do to make it more userfriendly.
Click to expand...

This is typical of using Access as a front-end, linked via ODBC, to server
databases. Once a new record is written to the server, its location is not
automatically passed back to the front-end. As far as I am aware, the same
is NOT true of updates, so I am not sure you have the same problem. We
avoided the problem by using a stored procedure on the server which created
a new record and returned its ID.

It is always useful to explain the context in which your database is
operating. I am not aware that a similar problem exists, by the way, for
Access using an MDB database file via the Jet database engine.
I have also noticed that the field and receord
validation is not in operation. Could you help
with that too. Of cours I could do validation
in VBA but if there's an easiest way...
Click to expand...

"is not in operation" isn't very specific. Again, the better the information
provided in a question, the better the answers are likely to be. Also again,
this sounds as if you have a client-server arrangement. If so, the
validation must be handled in "triggers" on the server database, or properly
defined Control validations on Forms, or in code in the BeforeUpdate event.

Larry Linson
Microsoft Access MVP
 
A

Andre Comeau

Thanks a lot Larry for your help...

To avoid problems adding a new record, I just add a field timestamp(14).
don't ask me why, I really have no idea. I took this trick in this page:
http://mathinfo.ens.univ-reims.fr/Docs/MySQL 4.1.1/manual.fr_Clients.html#MyODBC_clients
(sorry, it's in french, but maybe you could find it in english, if you
really need it, just email me, I'm gone a search for you)

When I upgrade, I don't have anymore problem (I'm not sure what was
wrong with it, but it's OK now)

About validation, I'm gone a use Control validations on Forms, or in
code in the BeforeUpdate event.

thanks a lot and I'm sorry about my english beta 0.1.1 not appouved :)

Andrew
 
Top