?
Solved

Can multiple users simultaneously open and use Microsoft Access 2007 through RDP services (Windows Server 2008) without any issues?

Posted on 2010-09-19
3
Medium Priority
?
514 Views
Last Modified: 2012-05-10
We have 10 -12 users outside our university network that will use a Microsoft Access 2007 database via RDP Services (formally Terminal Services).
Will multiple users be able to open the the database at the same time and make changes via RDP services?  Thanks
0
Comment
Question by:PDSWSS
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 3

Accepted Solution

by:
AccessYourBiz_Com earned 2000 total points
ID: 33712492
Yes providing the users are not going to modify any objects in the database. They can however add/edit/delete data without any problems.
Just know that if a user deletes data that another user is viewing it will says #Deleted instead of displaying the data.
0
 
LVL 7

Expert Comment

by:powercram
ID: 33712496
Should work fine as long as the DB is designed to be shared.  Access will run fine for multiple users on RDP.
0
 

Author Closing Comment

by:PDSWSS
ID: 33712696
Thank you
0

Featured Post

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

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

WARNING:   If you follow the instructions here, you will wipe out your VTP and VLAN configurations.  Make sure you have backed up your switch!!! I recently had some issues with a few low-end Cisco routers (RV325) and I opened a case with Cisco TA…
After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

764 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