Jim
Tue Dec 30 11:28:46 CST 2003
>-----Original Message-----
>Hello,
Howdy.
>I have a database that stores my hours worked on a
>project. Currently I copy the DB and the vb app on a usb
>thumbdrive. I run a web server, so I was wondering if I
>could just copy the 3 databases(DataStorage, SettingDB &
>System.mdw) to my web server. I could then access these
>via the web. But I am sure how I would address my
>connections? ODBC? Has anyone done this before?
In general, you can't open an Access database across the
network using an
http:// address, the way you can using a
UNC (\\server\sharename) address.
The trendy approach would be to put the Access database on
the Web server, write a Web service to perform the queries
and updates you need, and then change the vb app to use
the Web service. Of course, this is a tidy bit of work.
A more common approach is to put the database on the Web
server, and then rewrite the vb app as an ASP or ASP.NET
page. That way, all the processing occurs on the Web
server.
The simplest approach, of course, is to set up a scheduled
task that FTPs the database up to your Web site once a day
or whatever.
Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------