how could connect database via internet?

[Tracy]

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

 

[Albert D.Kallal]

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

I explain about this here:

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

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.members.shaw.ca/AlbertKallal//Wan/Wans.html

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.

 

[dbahooker]

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

 

[Albert D.Kallal]

This will work due to performance
issues

Should read:

This will NOT work due to performance
issues

 

[John Vinson]

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

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]