dandavis1
Posts: 18
|
| Posted: 06/21/2007, 9:45 AM |
|
Hi, thanks in advance for your time and any advice:
My code charge application is running fine on a remote windows web host. It's writing to a Microsoft Access database on the web host. But every time I want to "get" the records to download them onto my local computer and run queries in conjunction with other local Microsoft Access database, I have to FTP in and download the updated Microsoft Access database from my web host server. Is there any way to get the records in the remote web database to appear as if they are on my local computer without having to FTP download the remote Microsoft Access database every time there's an update by a user?
Sincerely,
Dan
|
 |
 |
E43509
Posts: 283
|
| Posted: 06/21/2007, 9:57 AM |
|
Not that I know of ... I do the same thing
|
|
|
|
andrefogelman
Posts: 117
|
| Posted: 06/22/2007, 4:36 PM |
|
Are you able for example to establish a VPN with the remore host?
|
|
|
|
dandavis1
Posts: 18
|
| Posted: 06/22/2007, 7:01 PM |
|
No. Basic Windows hosting package doesn't offer VPN.
|
|
|
|
Wkempees
|
| Posted: 06/25/2007, 6:28 AM |
|
Just to ease your 'pain', I give you my thoughts, as I don't think that
the situ you describe is that much of a problem, in fact it has an
advantage.
Analogue to your situation I develop PhP/MySQL.
On my local development system I hav an XAMPP install.
So on my local machine there is a Apache and MySQL instance.
During development all is on the local system.
The remote (publishing) server also is a Apache/MySQL PhP setup.
When I finish (a section of) the development (and tested) I switch CCS
to Server Profile 2 and publish.
Next I startup Navicat to synchronize the databaselayout from local to
Remote, which completes in general the publishing process.
From this moment on both database have same layout, but can have
different data.
If I want the local database to be equal to the remote database, using
Navicat I synchronize the data from remote to local. (= your FTP)
I can, but most Hostingproviders do not allow, connect directly from
Local development system to my Remote MySQL database. But I won't as
there are external users on that Database so any development or testing
that in fact changes data in the Remote database could mess-up live data.
So, as every disadvantage has an advantage, you will never unknowingly
mess up the data on you live Database. Unless you FTP the wrong way lol.
Walter
|
|
|
|
dandavis1
Posts: 18
|
| Posted: 06/25/2007, 11:36 AM |
|
Thanks Walter.
|
|
|
|
peterr
Posts: 5971
|
| Posted: 06/25/2007, 12:28 PM |
|
Dan,
I believe MS Access doesn't support such remote connectivity. One possible solution may be to use MySQL or MS SQL Server database on your server (convert your data to that format), then later you can create linked tables in your local MS Access database, linked to the external database on your server. They will appear as regular local tables in your local MS Access.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
dandavis1
Posts: 18
|
| Posted: 06/25/2007, 1:48 PM |
|
Yeah that would be ideal, thanks. Unfortunately I don't know SQL or MySQL. I don't suppose you've got a quick and dirty set up for this somewhere?
|
|
|
|
|
