Hi, I have an Access database located on an webserver which I need to be able
to create a Live Connection to so that when I update the databse on my
network it automatically updates the database on the website. At the moment
if I upodate the databse stored locally I have to publish the file using
Front Page to get the remote database to update which is not ideal.

Is there any way (except for VPN as the host doesnt allow it) that this
"Live Link" could be achieved. I have tried things like briefcase etc but to
no avail.

Thanks

Windows XP Pro
Access 2003 Pro
Front Page 2003 Pro

"Aaron Kempf2" <(E-Mail Removed)> wrote:

>you can't use Access MDB over a VPN

Well, you could but it would be exceedingly unwise as it would be prone to
corruptions.

>you would need to use SQL Server and Access Data Projects in order to do
>this

SQL Server sure but there is no need for the quirks of deprecated ADPs.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

mooseless05 <(E-Mail Removed)> wrote:

>Hi, I have an Access database located on an webserver which I need to be able
>to create a Live Connection to so that when I update the databse on my
>network it automatically updates the database on the website. At the moment
>if I upodate the databse stored locally I have to publish the file using
>Front Page to get the remote database to update which is not ideal.

Certainly not ideal as you would lose all the updates to the database since the last
time you downloaded it.

>Is there any way (except for VPN as the host doesnt allow it) that this
>"Live Link" could be achieved. I have tried things like briefcase etc but to
>no avail.

Not to my knowledge.

Can you put your database into SQL Server on the web hosting service and does the web
hosting service then allow you access to the data?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

you can't use Access MDB over a VPN

you would need to use SQL Server and Access Data Projects in order to do
this


"mooseless05" <(E-Mail Removed)> wrote in message
news:F3A25518-FCA5-46B5-AFA6-(E-Mail Removed)...
> Hi, I have an Access database located on an webserver which I need to be
> able
> to create a Live Connection to so that when I update the databse on my
> network it automatically updates the database on the website. At the
> moment
> if I upodate the databse stored locally I have to publish the file using
> Front Page to get the remote database to update which is not ideal.
>
> Is there any way (except for VPN as the host doesnt allow it) that this
> "Live Link" could be achieved. I have tried things like briefcase etc but
> to
> no avail.
>
> Thanks
>
> Windows XP Pro
> Access 2003 Pro
> Front Page 2003 Pro

Hi Tony,

Many thanks for your response, I don't think that a live connection is going
to be possible, but is it possible to have the two databases synchronise by
setting up a button that is clicked in the local database.

"Tony Toews [MVP]" wrote:

> mooseless05 <(E-Mail Removed)> wrote:
>
> >Hi, I have an Access database located on an webserver which I need to be able
> >to create a Live Connection to so that when I update the databse on my
> >network it automatically updates the database on the website. At the moment
> >if I upodate the databse stored locally I have to publish the file using
> >Front Page to get the remote database to update which is not ideal.
>
> Certainly not ideal as you would lose all the updates to the database since the last
> time you downloaded it.
>
> >Is there any way (except for VPN as the host doesnt allow it) that this
> >"Live Link" could be achieved. I have tried things like briefcase etc but to
> >no avail.
>
> Not to my knowledge.
>
> Can you put your database into SQL Server on the web hosting service and does the web
> hosting service then allow you access to the data?
>
> Tony
> --
> Tony Toews, Microsoft Access MVP
> Please respond only in the newsgroups so that others can
> read the entire thread of messages.
> Microsoft Access Links, Hints, Tips & Accounting Systems at
> http://www.granite.ab.ca/accsmstr.htm
> Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
>

mooseless05 <(E-Mail Removed)> wrote:

>Many thanks for your response, I don't think that a live connection is going
>to be possible, but is it possible to have the two databases synchronise by
>setting up a button that is clicked in the local database.

Not really. Unless you setup some code that fetched web pages full of data for this
specific purpose.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

mooseless05 <(E-Mail Removed)> wrote in
news:BE11AF31-391A-4E5A-8836-(E-Mail Removed):

> is it possible to have the two databases synchronise by
> setting up a button that is clicked in the local database.

In the right circumstances, you could do this with replication. But
it's doubtful that you can with a web server involved.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Tony;

what the hell are you talking about:

re:

>Is there any way (except for VPN as the host doesnt allow it) that this
>"Live Link" could be achieved. I have tried things like briefcase etc but to
>no avail.


Not to my knowledge.




NOW WHY IS IT THAT HE SHOULDN'T USE ADP?

ADP HAS NOT BEEN DEPECRATED, MDB IS DEPECRATED, DOG
CAN YOU CREATE A NEW MDB IN ACCESS 2007?

WTF KID STOP SPREADING LIES

On May 24, 4:30 pm, "Tony Toews [MVP]" <tto...@telusplanet.net> wrote:
> mooseless05 <mooseles...@discussions.microsoft.com> wrote:
> >Hi, I have an Access database located on an webserver which I need to be able
> >to create a Live Connection to so that when I update the databse on my
> >network it automatically updates the database on the website. At the moment
> >if I upodate the databse stored locally I have to publish the file using
> >Front Page to get the remote database to update which is not ideal.
>
> Certainly not ideal as you would lose all the updates to the database since the last
> time you downloaded it.
>
> >Is there any way (except for VPN as the host doesnt allow it) that this
> >"Live Link" could be achieved. I have tried things like briefcase etc but to
> >no avail.
>
> Not to my knowledge.
>
> Can you put your database into SQL Server on the web hosting service and does the web
> hosting service then allow you access to the data?
>
> Tony
> --
> Tony Toews, Microsoft Access MVP
> Please respond only in the newsgroups so that others can
> read the entire thread of messages.
> Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm
> Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/