Solved

How can I set up Access so that multiple people can view reports and forms at the same time?

Posted on 2011-03-01
1
216 Views
Last Modified: 2012-06-21
I want to use Access with the same capabilities as Excel or ord where, if someone else is using it, I can still go in and iew it, whether reports, or queries, etc.  Is there a way to set that up or the abilitiy for multiple people to go in and enter information at the same time?  I have mine set up with a front end and back ends.
0
Comment
Question by:tlahpalli
1 Comment
 
LVL 77

Accepted Solution

by:
peter57r earned 500 total points
ID: 35007362
Then just give each person a copy of the front-end.  

The backend needs to placed in a shared folder accessible to everyone.  If you have to move it from its current location to do that, then you should move the backend first, then re-link your frontend to it and then distribute copies of your re-linked frontend.
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now