How to open Access DB on web server

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know this may be simple for most, but I am not that knowledgable about
doing this. I have a website with an Access 2000 DB. I have built the
tables to collect all the data I need and I am having someone else build the
forms. I want to be able to open the DB on the web server directly from my
computer w/o having to open FrontPage 2002 first. I also have another Access
DB on my computer and need to automatically append data collected from the
website to this DB, but I don't know how to open it and/or to create a
relationship between them so I can see the tables in both databases. Is this
possible? If so, any help is appreciated.

Thanks. Keith
 
If you want to open a excel, word, power point, or in your case a mdb file,
then you need to be able to "browse to the folder where it resides.

Remember, a horse is a horse is a horse.
and, a file is a file is a file.

To open a mdb file, you need to be able to launch ms-access, and then go
file->open. You then must be able to "browse" to a shared folder on a
computer.

It is possible to setup a VPN (virtual private network) to a web server, and
thus you will "see" the folders in the "network neighborhood". (I don't know
of any providers that do this for you, but if it is your "own" web server,
then you can ask the admin to set up a vpn so you can then browse files on
the computer.

Remember, you are opening a file here...so to use the file, you MUST BE ABLE
TO browse to the folder via standard windows networking. If you can't browse
to the folder, then you can't open it, and if you can't open it, then you
can't use it!!! (it is REALLY very simple concept!).

The other problem however with a vpn is your high speed internet connection
is about 100 times slower then your cheap local area network.

So, you can read about using the internet, and connecting to a database from
ms-access here:
http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html
 
Back
Top