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
511 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 500 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 6

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

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

728 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