"Ove" <ov**********@merga.se> wrote in message
news:3a**************************@posting.google.c om...
I have one Access 2000 DB on my website. I want to access these tables
from my local database so i do not need to down-/upload the database
each time i want to make changes.
Meanwhile i want a external partner to access (just read) another
database on my web.
I have tried with "link tables" but do not succeed. Help please!
When you link tables, you must be able to "browse" on your network to the
file of your choice. So, the way to make this work is to setup networking
between your computer, and that web server. So, you need that other computer
to appear on your local network (just like you can network a few computers
together through a hub). This is usually called a VPN (virtual private
network). When you make a VPN, then all computers will appear in "my
network". In fact, the computers can be all over the world, but appear as a
nice little happy network.
So, to "link" a front end to the back end, you have to be able to browse to
the folder via "my networks". If you can't simply browse, and look at
folders via your network neighborhood, then you can't browse to the files
when you try and link.
Of course, the problem with is approach is that your connection is 100 times
slower over the web (and I am taking a t1, or a high speed internet).
There are some solutions to this problem here:
http://www.attcanada.net/~kallal.msn/Wan/Wans.html
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com http://www.attcanada.net/~kallal.msn