Access db to MySQL

[Minty]

I would create a new test table in MySql and just play around with the options and data types available - you won't be damaging your existing structure or data that way. It's going to be better in the long run if you learn now.

When it comes to importing the real data as long as you have a backup copy anything you do wrong can always be corrected.

 

[anishkgt]

Yea thats what am doing i have the copy of the back that is running now. And with mysql i use a copy.

 

[anishkgt]

Things are looking better now. All working well and figured that the Auto Number only generates after that record is exited. Does not display as a new record is added.

 

[anishkgt]

Solved that too. Does anyone know how the Before delete trigger can be used to move records to another table before deleting and update a field in the new table. Inserting into another table is ok but at the same time i want update another field too. i get an error like Column and list mismatch.