🚀 go-pugleaf

Unfortunately, it is not directly possible. The reason this works for
SQL server is because there is a database server program running on your
server, and it can be invoked over TCP/IP. This is not the case for
Access.

If you want to do this, there are a few ways...

1) If your hosting company lets you run CGI programs written in
languages other than Perl, you can write a form processor using the BCB
web components and have it update the database.

2) If not, but your hosting company supports ASP pages, you can use a
tool like Dreamweaver Ultradev
(http://www.macromedia.com/software/ultradev/) to create an ASP page
that will let you update the database (you can also create such a page
by hand, though it is significantly more difficult that way).

3) You can update the database local to your machine and copy it to the
destination machine. I have had occasional problems with this, but it
can work.

4) You could use BCB to write a generalized "Access DB Server" program,
if you can run such a thing at your host company server. Then you could
write a client program for it (perhaps using sockets for communication)
and do your updates that way.

I hope this helps. Personally, I recommend (2) as the easiest and
likliest to be acceptable to a hosting company

------
Mark Cashman (TeamB - C++ Builder), creator of The Temporal Doorway at
http://www.temporaldoorway.com
- Original digital art, writing, music and more -
C++ Builder / JBuilder Tips and The C++ Builder Programmer's Webring
(Join us!)
http://www.temporaldoorway.com/programming/index.htm
------