how could connect database via internet?

how could connect database via internet?

Post by Trac » Sun, 15 Jan 2006 07:19:21


Hi,

if my database was on one server, such as in other country; my application
is on another server, such as in U.S. how could i make the connection?

Thanks alot!!
 
 
 

how could connect database via internet?

Post by Albert D.K » Sun, 15 Jan 2006 07:55:28

First, we have to assume that for any networked application, you been
splitting your application.

I explain about this here:

http://www.yqcomputer.com/

now, once you realize how the above works, then the temptation is to try and
run a split database over the internet. This will work due to performance
issues. However, I do explain how to run a ms-access applation in different
locations here:

http://www.yqcomputer.com/

So, you need to read and understand the first article above...and then you
can go on to read the 2nd article about having people in different locations
(or even countries) use the same ms-access application.

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
XXXX@XXXXX.COM
http://www.yqcomputer.com/

 
 
 

how could connect database via internet?

Post by dbahooke » Sun, 15 Jan 2006 08:01:09

splitting?

splitting is GAY

MDB is for WIMPS

use Access Data Projects and SQL Server or MSDE.

i mean-- it's the same price as MDB; but for example-- you can force
encryption
MDB is just obsolete; run away while you still can
 
 
 

how could connect database via internet?

Post by Albert D.K » Sun, 15 Jan 2006 08:30:56

>This will work due to performance
issues

Should read:

This will NOT work due to performance
issues
 
 
 

how could connect database via internet?

Post by John Vinso » Sun, 15 Jan 2006 08:32:13

On Fri, 13 Jan 2006 17:19:21 -0500, "Tracy"



Not using two Access databases in frontend/backend configuration, for
sure! Access is MUCH too demanding of network speed and purity to work
at all reliably over a WAN in this way.

What I've done for my clients is to recommend that both the Access
frontend (or Visual Basic application in one case) and the database
backend be on one server (the one in the US). This server would need
to either have Citrix Server installed, so the client could use Citrix
Client to link to it as a termial session; or (though I haven't tried
this) use WindowsXP Terminal Server to provide a similar link.

The alternative is to use a web-enabled application, probably using
SQL/Server or SQL/Server Express Edition as the data storage medium
and an ASP webpage. This will be a major redesign effort from an
Access database unfortunately!

John W. Vinson[MVP]