Access with Mysql question

[genesis]

Good day!

I have no idea about my question and I am still learning mysql. I would like to ask if how can I....

a) embed mysql in access project
b) synchronize two mysql database using access only.


thank you very much.

 

[Banana]

Exactly why do you want to embed MySQL database? What do you hope to accomplish from this?

Furthermore, you are aware that to have a embedded MySQL solution, you would have to pay for it, yes? MySQL has a dual licensing where it's free to use the community server but you have to pay for embedded server.

Finally, it's kind of pointless as Access already has a good engine, Jet, for its use and you can just synchronize the local table with the central databases.

Maybe if you describe more about what you hope to accomplish from this, what your workflow/environment are, we can offer more useful advices.

 

[genesis]

I am using access as front end and mysql as backend. and I want it embedded in my project so that if the customer who will install the project will no need to install mysql separately.

I dont have an idea that i have to pay for the embedding of mysql. I thought it was free and upon my installation it appears an option there embedded server.

our company has 3 branches and I would like to synchronize the data from their branch data so all of the branches data will be updated. we are not using internet connection.

mysql is the choice for backend as i have been directed.

 

[Banana]

I actually answered an similar question from another poster whom asked about embedding and needing to synrchonize between offices without internet connection.

Here's the thread. Note my answer in post #6

 

[genesis]

yeah somewhat same problem. but I think it lacks information that I need. How about my question post number 3 sir?

 

[genesis]

i have created database and tables in it using the workbench. and tried using third party software for it for gui. as I have been exploring mysql regarding security, i cant seem to know how I will password protect that database or that connection so that no one can open that database without password. can you also direct me to that information?

 

[Banana]

As the post #6 alluded to, you would probably want to install 3 MySQL server for each branch, and set up a script running SELECT INTO OUTFILE or use mysqldump to generate a text file which you can then send to other branch for synchronizing. As explained, you need to guarantee that each server assign a unique ID for all tables to avoid primary key conflict. This is done by configuring the auto_increment_offset and auto_increment_seed.

You can look into MySQl manual at mysql.com for more infromation for those.

 

[Banana]

i have created database and tables in it using the workbench. and tried using third party software for it for gui. as I have been exploring mysql regarding security, i cant seem to know how I will password protect that database or that connection so that no one can open that database without password. can you also direct me to that information?

You would basically assign a different user account that doesn't have the permissions to do any DDL but DML only. Refer to MySQL manual, specifically 5.4 and 5.5.