468,136 Members | 1,444 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,136 developers. It's quick & easy.

Need quick pointers on accessing MDB file on a Web Server

Can someone point me to the best concentration of info on manipulating
an MDB file via VBA and HTTP?

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
Mar 15 '06 #1
3 1514
LW

If you want to use ASP and VBScript, you could check out my article
at Database Journal

http://www.databasejournal.com/featu...le.php/3487741

Danny Lesandrini

Mar 15 '06 #2
Lauren Wilson wrote:
Can someone point me to the best concentration of info on manipulating
an MDB file via VBA and HTTP?


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
'---------------
Mar 16 '06 #3

Thanks very much John! THIS is the kind of response I was hoping for.
I regret there is not an easier way to do this but, this just means
that I can now safely turn my attention to different strategies,
without fear that a simpler approach has been overlooked.
On Thu, 16 Mar 2006 05:40:58 GMT, John Mishefske
<jm**********@SPAMyahoo.com> wrote:
Lauren Wilson wrote:
Can someone point me to the best concentration of info on manipulating
an MDB file via VBA and HTTP?


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.

Mar 16 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by Snake | last post: by
1 post views Thread by datapro01 | last post: by
12 posts views Thread by Ron Weldy | last post: by
7 posts views Thread by Roshawn Dawson | last post: by
8 posts views Thread by pamelafluente | last post: by
memoman
4 posts views Thread by memoman | last post: by
1 post views Thread by gcdp | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.