Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Multiuser / Networking / June 2005

Tip: Looking for answers? Try searching our database.

multiuser over net

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
JB - 24 Jun 2005 17:17 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.