 Re: How to avoid ftping data all the time
"Rakshas" <rvaidyaraj@gmail.com> wrote in message
news:1123596061.681823.64870@g43g2000cwa.googlegro ups.com...[color=blue]
> 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.[/color]
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
| 
