Search results

Accessallinone.com that site offers service and you tube tutorials on ms access.

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.

By the way, got the answer to my 22 post

I think yous should be better off with MySQL if you need the backend as MySQL and front to be access forms. I am also trying to the learn the MySQL thing since am thinking of migrating my database to MYSQL.

hi I had the same issue but the error was ODBC - Insert on a linked table 'tblDelivery' failed. So is there are a way to change the field to a YES or NO in MySQL like similar to a check box in Access because selecting those fields, a delivery is deleted from that table and appened to another...

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.

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

Thanks minty. Thats a little too complex. Anyways will google some.

ok found the place to do that, that has to be set with the MySQL user. That was strange, did not know with the database itself there were restrictions. So i checked the AI and G and when applied it gave this error Operation failed: There was an error while applying the SQL script to the...

This is not on a domain but on a workgroup basically on local pc. how is the rights sets on MySQL. Since the front end is connected via the ODBC how can we see who is connected. There is tab for user and privileges and the ODBC is connected via root user. I can add records from the front end...

Ok got it done ! Attached here are some pics showing the status of the db. I've migrated the access db to MySQL. Linked this db to the front end. Tried adding some data to this table but it seems like there seems to be some rights. I could see that a primary key is not generated when a new...

Jdraw, The main concern is a way to monitor CPU usage, connections to the db, users connected, network activity to and fro from the db. So thought i'd give MySQL a try.

Ok migrated the Access db to MySQL (https://dev.mysql.com/doc/workbench/en/wb-migration-database-access.html) now trying to link them from Access

The ODBC connection is what am trying to figure things out. how do i connect it to the MS access DB? but before that i have to migrate the existing access db to MySQL. how do i migrate it to the MySQL ?

Now am wondering if i need to have an ODBC connector, i think i will have to just migrate the existing Access db to MySQL. any ideas anyone ?

hey sneuberg ! When coming to the ODB connection part, is that something done after having a DB already setup in MySQL ? will have to learn how to do that. are there any steps to convert the existing Access db.

Ok found this on the way video tutorial https://www.youtube.com/watch?v=zu-8T4ERPN8 So i am guessing i have to migrate my existing table for ms access to MySQL, rite ? how do i do that ?

Thanks sneuberg. Tried that app but there was some need to add an odb connector which i had no idea how to. I am hoping to do do so but seems like that i won't be possible by a noob. The existing setup has no problem as such but i wanted to see if this is possible as the MySQL is able to moitor...

Hi All, does anyone know how to transfer existing Access db to mysql. Would this increase performance as in searching and loading of the data.

Ok got it ! :) seems that although the PNR was available as i type the code but the PNR on the report was simple text also added into it so added another PNR field and that solved it.