I need to update my acces database (.mdb) from an external computer

Question

I need to update my acces database (.mdb) from an external computer

Navigation

#1 by (0 votes)

0

Hello, I have a client with two stores and I need the database to be interlaced. I need a primer on how to start studying this.

obs: the database is local, not in the cloud

visual-basic-6 ms-access

asked by anonymous 16.11.2017 / 20:37

1 answer

Chat between two different computers Procedure does not return the entire column

score 0 · Accepted Answer

Hello,

I made a System in Access with VBA that I 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 SQL knowledge (Select, Update and Insert) you have already been able to do many things. There are lots of videos to help with Mysql, so the instructions are easy to do. With Mysql you will need to use ADO or DAO VBA. I like ADO. Below I will link a Video from the Excel Guru. It explains how to connect an Excel Form with Access. You can use all the forms of connection that it explains only by switching to Mysql.

link

Note: to connect with Mysql you will need to have Oldb Drive on the machine. I use version 5.3. If you want, I'll give you an Access connection with Mysql.

I hope I have helped