Connection string

radek225

Registered User.
Local time
Today, 12:23
Joined
Apr 4, 2013
Messages
307
I have a back of my base on ftp. Now I working on my base using front which is in local network. But I would like to work online. So I have to connect to my base from the internet. I read about connection string. But where should I past code of connection string and how to use it? Is there someone who know how to connect?

Code:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\\ServerFTP\base\myAccessFile.accdb;
Jet OLEDB:Database Password=MyDbPassword;
 
I'll be watching this thread but as far as I know you cannot work 'live' on an Access database backend stored on the web.
You need to look at a variant of SQL for that.
 
What about VPN? How looks work with data from this connection? It's could be good solution? I heard about web aplication in MS Access 2013 someone work with this? It have matter when I will have a SQL server (online work matter)?
 
The way our databse works is like this:
All users are on the frontend with the backend on their own local server.
As soon as any of the users logout, the lastest dataset gets uploaded to the web.
This then gives all remote users access to the latest dataset but only on a read-only basis.
The solution works for most of our clients since remote users only want to look up stuff while the office staff are the ones processing the data.
 

Users who are viewing this thread

Back
Top Bottom