"Rakshas" <rv********@gmail.com> wrote in message
news:11*********************@g43g2000cwa.googlegro ups.com...
Looking for a solution where I can have a desktop app that updates the
mdb file on my server automatically without having to FTP the table.
Even better would be some kind of a web form that does the updating. I
know I can code this myself but if there is a built in solution within
Access, I would pee myself in happiness.
If your server is on a LAN with the desktop system on which the user would
be running Access, you can simply split the database into front-end
(queries, forms, reports, macros, modules, and perhaps some local lookup
tables) on each user's machine and a back-end (tables, relationships, and
data) in a shared folder on the server, link the tables in the back end on
the server from the front-end on the user's machine, and use them as if they
were local.
If your server is across a slow WAN or the Internet, you'll need to use a
different approach. The only one that is all-Access is Data Access Pages...
usable only on a Windows server with Access installed, by users running
Internet Explorer 5.5 or later, with the Office Web Extensions installed. As
with most web-based applications, the UI cannot be nearly so rich as Access
or other local UIs. It is not exactly a "wave the magic wand and your Access
database is on the web and accessible" but it should be easier than creating
a web-based database with ActiveX Server Pages (.asp) or ASP.NET.
Larry Linson
Microsoft Access MVP