Need to do all the standard stuff for a flat-file database: locate and
retrieve records by ID col, Insert new records, edit and delete
records and return record data as XML or even Comma,Quote Delimited
text.
Any pointers to the quickest VBA code examples for doing this would be
much appreciated.
Thanks all,
-- LW
If you want to use ASP and VBScript, you could check out my article
at Database Journal
http://www.databasejournal.com/features/msaccess/article.php/3487741
Danny Lesandrini
There are many different potential solutions. One way to work with Access .mdb via a
web server interface is to use Perl and the DBI module and write a CGI program.
Check out ActiveState Perl. Use its PPM utility to download the DBI module and
Google for some samples.
You mentioned VBA; Microsoft's ASP supports the use of VBScript as a language
for developing web apps that can interact with Access databases.
A big influence on how you do web access will depend on what your web host provider
makes available or what you've installed as a web server (Apache, IIS, etc.).
Unfortunately there is a substantial investment in time to learn to integrate
the various technologies to create a web solution.
--
'---------------
'John Mishefske
'---------------