Working remotely from my home office, I'm helping a very small non-profit
with a improve their fundraising and membership database. Becasue they have
very limited resources, I can only work part time and have to be very
cost-effective with what I do, so I've tended to favor "quick and dirty"
fixes.
First I converted the primitive original dtabase it to a proper relational
database using the Office XP Pro version of Access. Then I FTP'd the new
.mdb to a secure folder on our web server, and trained the the office
volunteer how to download it, o input records properly, use queries and
reports, and upload the updated copy.
She inputs new records, and I work on things like new queries and reports.
The difficulty is in the FTP'ing, exporting. etc. It's not really like we're
working in the same office with a "split front and back end" as described in
this forum. What I'd really like is something where a trusted fundraiser
could see the entire database record for each donor while they're contacting
them, and make changes to the database record on the spot, remotely. We're
rapdily moving to a point where we will have three or four people who need to
make changes to the database remotely and fairly simultaneously, and FTPing
updates can only really work if only two people are doing it. I tried
setting up published Web database pages, but that's really over my head. I
just a self-taught, amateur, and I need a basic overview of my options, with
good tutorials. Suggestions, please; links?
Thanks
JB
Douglas J. Steele - 24 Jun 2005 22:13 GMT
Sounds as though you need to look into Replication.
The Access 97 Replication FAQ (which I believe is still relevant to newer
versions of Access) is available at
http://support.microsoft.com/default.aspx?scid=kb;en-us;182886
A warning, though: it's a very complex topic!

Signature
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
> Working remotely from my home office, I'm helping a very small non-profit
> with a improve their fundraising and membership database. Becasue they
[quoted text clipped - 32 lines]
> Thanks
> JB
Larry Linson - 25 Jun 2005 00:59 GMT
>... converted ... to a proper relational
> database using the Office XP Pro ver-
>sion of Access. Then I FTP'd . . .
> ... It's not really like we're
> working in the same office with a
[quoted text clipped - 3 lines]
> the entire database record for each donor
> while they're contacting them, and make changes to the database record on
the spot, remotely. We're
> rapdily moving to a point where we will have three or four people who need to
> make changes to the database remotely and fairly simultaneously, and FTPing
> updates can only really work if only two people are doing it. I tried
> setting up published Web database pages, but that's really over my head. I
> just a self-taught, amateur, and I need a basic overview of my options, with
> good tutorials. Suggestions, please; links?
If you have another volunteer who knows something about networking, you
might consider using a Virtual Private Network to connect, give each user
their own little disk space and their own copy of the front end, and do
multiuser all on the server.
There is even some free VPN software, but you'd have to Google this
newsgroup and/or the USENET newsgroup comp.databases.ms-access for details.
One recent thread dealing with Microsoft Terminal Server for multiuser is
http://groups-beta.google.com/group/microsoft.public.access/browse_thread/thread
/3eab19eaeef2d105/d88f77492c46527b?q=Kallal+%22Terminal+Server%22&rnum=1&hl=en#d
88f77492c46527b
Also, MVP Tony Toews' site is a goldmine of information on using Access in
the multiuser environment -- http://www.granite.ab.ca/accsmstr.htm.
Larry Linson
Microsoft Access MVP