Question:
Can E3 connect to an Access remote database?
Solution:
Yes. To do so, Access’ .MDB file must be in a shared folder on the network.
To create a shared folder:
– right-click the folder, and access its properties:
![](http://kb.elipse.com.br/pt-br/images/ID4443/img1.bmp)
– on Sharing tab, click Advanced Sharing… button:
![](http://kb.elipse.com.br/pt-br/images/ID4443/img2.bmp)
– on the next screen, check Share this folder, and then click Permissions:
![](http://kb.elipse.com.br/pt-br/images/ID4443/img3.bmp)
– check the option Full Control for user Everyone:
![](http://kb.elipse.com.br/pt-br/images/ID4443/img4.bmp)
– At E3, set Database object with the folder’s path on the network, and write the name of the.MDB to be created, according to the example below:
![](http://kb.elipse.com.br/pt-br/images/ID4443/Img5.png)
IMPORTANT: when opened in a Microsoft Access database, this file can be blocked for edition (as seen in the figure below with banco3):
![](http://kb.elipse.com.br/pt-br/images/ID4443/img6.bmp)
In this case, E3 may not be able to access the file. To remove its protection, open the file in Access, go to File–Info menu, and select Compact & Repair Database:
![](http://kb.elipse.com.br/pt-br/images/ID4443/img7.bmp)