Writing to Web-based Database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I am trying to build VBA code that will write to a database located on
a web server. Database is MS Access now, but could use SQL Server or
something else SQL based. How can I automate the process of opening,
appending, and closing a database when the Office application is on
the local computer but the database is on a web server?

Thanks

.

Relevant Pages

  • Re: Re: Need info, books, articles,code, etc: Access VBA to XML to/from MySQL via HTTP
    ... read, update, add and delete records located in tables in a MySQL database ... on a Web server on the Internet directly from my desktop Access application, ... the workstation needs a secure shell client running in order to enable the ... the MySQL database on your workstation ...
    (comp.databases.ms-access)
  • Re: How do you store .JPG in ACCESS using VB.NET
    ... that connects to SQL Server directly. ... You may find some helpful VBA code and information at Stephen Lebans' Web ... See http://www.QBuilt.com for all your database needs. ...
    (microsoft.public.access.modulesdaovba)
  • Re: ADP PICK database connect to SQL
    ... > all database programming outside of using PHP with mysql. ... The Pick DBMS has its ... > importing them into sql. ... conduit (ultra thin web server), and the Pick DBMS as both application ...
    (comp.databases.pick)
  • Re: SQL conversion
    ... SQL Server can likely provide XML ... wanted to do a direct link from the web server to the SQL-1 machine, ... This database on the SQL is just basically a membership database, ...
    (comp.lang.clipper)
  • Re: Data transfer/input from external website
    ... BUT this would mean exposing your SQL server to external ... you could leave it on the web server in an Access or XML ... > database for automated processes you setup. ... > web service to only include the IP of the external web server (and/or ...
    (microsoft.public.windows.server.sbs)