We help IT Professionals succeed at work.
Get Started

How to Deploy MS Access Application so multiple offsite users can update simultaneously

GTC-KTX
GTC-KTX asked
on
1,169 Views
Last Modified: 2013-11-29
I have a sales database which i've been developing that will track sales opportunities of our salesforce.  The salesforce is obviously located in the field, and will rarely be in the main office.  They will therefore be updating their data from home (likely on a nightly basis).  I'm sure there will be many times when multiple salesmen will be trying to update at the same time.  I'm trying to figure out what the best way to implement this is.  I'm relatively new to Access and have not implement anything yet that needs updated by multiple people.

As far as remote access for the salesmen, they have two ways that they log on to our server.  For email, they log on to Outlook Web Access.  If they need access to our server or an office computer, we do that through Remote Web Workplace (SB Server 2003).  They have never really had the occasion to do much more than the Outlook Web Access until now.

Any help on how to implement this would be appreciated.  I guess the main thoughts/questions  i have are as follows:
1.  how do i properly account for the fact that multiple users may be trying to update or open the database at the same time?
2.  Do i need to worry about users corrupting the form or database?  is there anything i should do about that?
3.  Also, i've read a little bit that Access 2007 (which i am using) has some sort of e-mail update capabilities.  Not sure how robust this functionalitiy is and if it would work with a fairly complex input form that has multiple tabs and subforms.  If this is a viable possibility for me, i'd like to know if its the best way to pursue.

Anything else that i haven't thought about yet or didn't mention?
Comment
Watch Question
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 4 Answers and 9 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE