MS Access on Web

[Peter K]

I need to link tables from an Access97 db held on a web server and would use
a broadband/ADSL for this purpose.

If a convetionally linked table can't be achieved, I would need to address
the web DB by reading and writing and deleting data. I haven't go a clue
what to do. Can anyone help or at least point me in the right direction?

[Clive Moss]

I started with ASP but your ISP would have to support it.
I found that my host needed the db in 2000 file format for the script to
work.

CM

"Peter K" <pe****@kaasen.plus.com> wrote in message
news:xR******************@wards.force9.net...

I need to link tables from an Access97 db held on a web server and would use a broadband/ADSL for this purpose.

If a convetionally linked table can't be achieved, I would need to address
the web DB by reading and writing and deleting data. I haven't go a clue
what to do. Can anyone help or at least point me in the right direction?

[Jerry Boone]

As far as I have found you have to have one of these things to link a table:

Physical Drive (hard drive, et.)
Virtual Drive letter (mapped network drive)
ODBC DSN

Unfortunately unless you have direct access to one of those you aren't going
to get a linked table. Since the access ODBC driver only lets you specify a
file path, it's not going to work. If you could VPN to your web server
(would require your ISP to set this up) then you could map a drive and get
it done. If you can't find anyone that can do this, let me know - we can
provide this capability, but performance will not be good if you have large
tables.
--
Jerry Boone
Analytical Technologies, Inc.
http://www.antech.biz
"Peter K" <pe****@kaasen.plus.com> wrote in message
news:xR******************@wards.force9.net...

I need to link tables from an Access97 db held on a web server and would use a broadband/ADSL for this purpose.

If a convetionally linked table can't be achieved, I would need to address
the web DB by reading and writing and deleting data. I haven't go a clue
what to do. Can anyone help or at least point me in the right direction?