I created ODBC data source but I had to suffer much to make this. I did not know that there was MySQL connector readymade software. Thanks for this presentation.
Omg that intro "hi_friends" it just sounded like "if you're watching this video you're probably some sort of geek and are just as lonely as I am, let us share our loneliness together"
thank you very much sir, when MySQL server is offline the data won't be inserted in MS Access, Is there anyway overcome this situation, thanks in advance
I have a local access db with a lot of data being imported from Exe file made for that, i want to sync data to mysql even when the access db is in use by exe How can I?
You have to use the Microsoft SharePoint server to access your database remotely, but your database must be web database compatible. You May go through this article: support.microsoft.com/en-us/office/build-an-access-database-to-share-on-the-web-cca08e35-8e51-45ce-9269-8942b0deab26
Is there a row limit when connecting a large database to Access like this? I know when I tried creating a local database in Access I was capped at like 2M records. I have 20M + rows and I'm hoping this can work.
if you create a linked table in Access database there is no limit. But if you want to make a local table in Access, the total size is maximum 2GB. The difference between linked table and local table is |-> in a linked table actual data stored in a remote database and local table data are stored in a local file.
@@TechBlogTutorial I'm trying to link an Accces databese to Mysql, but after all the step, I have an error message saying "ODBC call failed" instead of having te windows to select the table from Mysql database. I'm using Ms access 2010. What should I do to solve this problem? Thank you in advance for your advice! Kind regards,
@@TechBlogTutorial How to check network error from Mysql server, should I Start Mysql server before I link the Ms access To Mysql. How to check if the 3306 port is Accessible in my Host? Thank you! Kind regards,
Stupid question: Do I have to fill my TCP/IP address even if I just want transfer database from Acces to Mysql (and vice versa) IN THE SAME PC???? Thanks
@@TechBlogTutorial Last question: which version do I have to download? I have Windows x64 but as experienced in R, I know I have to pay attention and prefer x32 version. What do u suggest? Thanks again
Everything works fine in Access butt when I use ADO to connect to the Access frontend and i query a table linked to the MySQL backend it gives error - "Connection failed "
Is it better to use PHP for the front end (Interface)?..... At university i was taught SQL with MS Access...but now it is suggested to learn PHP with MYSQL
I created ODBC data source but I had to suffer much to make this. I did not know that there was MySQL connector readymade software.
Thanks for this presentation.
Omg that intro "hi_friends" it just sounded like "if you're watching this video you're probably some sort of geek and are just as lonely as I am, let us share our loneliness together"
Important: You must be loged as ADMIN in Office Access to set up the ODBC connection!!
Great, thank you. Really enjoy the locutus voice and music. :)
Many thanks!
thank you very much sir, when MySQL server is offline the data won't be inserted in MS Access, Is there anyway overcome this situation, thanks in advance
What are other alternatives to MS Access as a front end working with MySQL.
MySQL Workbench, PHPmyadmin etc.
thank you very much sir its really help a lot
I have a local access db with a lot of data being imported from Exe file made for that, i want to sync data to mysql even when the access db is in use by exe How can I?
You have to export table to remote db.
Is it possible to SSH tunnel to the remote sql serer using ODBC ? Some other sql clients got ssh options but I dont see ssh in ODBC
Hi, please advise on how to host my Microsoft access app on the cloud and access remotely through a web browser..
You have to use the Microsoft SharePoint server to access your database remotely, but your database must be web database compatible.
You May go through this article: support.microsoft.com/en-us/office/build-an-access-database-to-share-on-the-web-cca08e35-8e51-45ce-9269-8942b0deab26
This very helpful, thank you so much
You're very welcome!
Great video!!
Thanks
Excellent!
Thanks
Is there a row limit when connecting a large database to Access like this? I know when I tried creating a local database in Access I was capped at like 2M records. I have 20M + rows and I'm hoping this can work.
if you create a linked table in Access database there is no limit. But if you want to make a local table in Access, the total size is maximum 2GB. The difference between linked table and local table is |-> in a linked table actual data stored in a remote database and local table data are stored in a local file.
@@TechBlogTutorial I'm trying to link an Accces databese to Mysql, but after all the step, I have an error message saying "ODBC call failed" instead of having te windows to select the table from Mysql database. I'm using Ms access 2010. What should I do to solve this problem?
Thank you in advance for your advice!
Kind regards,
@@clubvoyage7541 this happened due to network error. Or might be your remote server out of network, or make sure 3306 port accessible in your host.
@@TechBlogTutorial How to check network error from Mysql server, should I Start Mysql server before I link the Ms access To Mysql. How to check if the 3306 port is Accessible in my Host?
Thank you!
Kind regards,
Stupid question: Do I have to fill my TCP/IP address even if I just want transfer database from Acces to Mysql (and vice versa) IN THE SAME PC???? Thanks
Yea, you have to use localhost/127.0.0.1
@@TechBlogTutorial Thanks! I'll try
@@TechBlogTutorial Last question: which version do I have to download? I have Windows x64 but as experienced in R, I know I have to pay attention and prefer x32 version. What do u suggest? Thanks again
@@elghark choose which is applicable in you environment.
I have a MS Access Program Written in VBA i need to host it online .......................how///////////////pleeeeese reply
Thank you very much... very helpful!
Everything works fine in Access butt when I use ADO to connect to the Access frontend and i query a table linked to the MySQL backend it gives error - "Connection failed "
Can You provide the Error Code? If I am not wrong you want to use your access database for an application which uses ADODB Connection?
Is it better to use PHP for the front end (Interface)?..... At university i was taught SQL with MS Access...but now it is suggested to learn PHP with MYSQL
PHP really shines when it comes to web development however Access for front end is pretty decent if you want a gui not (webpage)
I agree, but with MS Access the panel pretty much creates itself based on your tables. In PHP you'd have to do a bit more work
i installed odbc but i didn't get odbc in the menu. Help please
make sure you restart your system. and choose right version for your need.
Do you now a basic host name?
I didn't get your question.
after obdc link lost table relations how do I set them up again in access or php my admin ?
So far as I know its' does not effect on MySql Relation. But in Access, you have to create your relation under Database Tools Section(Tab)
where do i find my TCP/Ip
Your MySQL remote server ip
Does the video’s music have a name?
Jupiter_One is the name of Music. I found it under Audio Library of UA-cam.
my remote database does not appear on the drop down list
Have you tested your connectivity? using test connection button in MySQL connector box. And Have your User assigned to any database?
It didn't work
Let us know the issue you had faced
WTF...!!!