0
Hello, I have a client with two stores and I need the database to be interlaced. I need a north on how to start studying this.
Obs: the database is local, not in the cloud
1 answer
0
Hello,
I made a System in Access with VBA that used the Mysql Database. In case my E-mail provider ( Localweb ) makes the Database available for free. And I created several banks and used PHPMYADMIN to manipulate everything. If you have a Basic knowledge in SQL ( Select, Update and Insert ) you will already be able to do many things. There are many videos to assist with Mysql even because the instructions are easy to do. With Mysql Voce you will need to use ADO or DAO Vba. I like the ADO. Below I will put link to an Excel Guru Video. It explains how to connect an Excel Form with Access. You can use all the forms of connection it explains only by switching to Mysql.
Note: to connect with Mysql Voce you will need to have Oldb Drive on the machine. I use version 5.3. If you want, I pass you a connection of my Access with Mysql.
I hope I’ve helped
Browser other questions tagged database visual-basic-6 ms-access
You are not signed in. Login or sign up in order to post.
I believe that one way out of this is to have a third bank in the cloud and the pdv exchange information for that bank.
– davidterra