Connect to an access database on a webserver

[mooseless05]

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

 

[Tony Toews [MVP]]

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/

 

[Tony Toews [MVP]]

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/

 

[Aaron Kempf2]

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]

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]]

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/

 

[David W. Fenton]

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.

 

[aaron.kempf]

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