[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 524
  • Last Modified:

Is there a special option in Access 2003 (Office 2003 SP3) that will allow several users to open and modify the same Access database at the same time?

Is there a special option in Access 2003 (Office 2003 SP3) that will allow several users to open and modify the same Access database at the same time?

We have three users who need to be able to access and make modifications to the exact same Microsoft Access file (which is stored on a network share).

All users have full share and security permissions to this file.

Is there some sort of special option I need to specify or choose in Access 2003 (Office 2003 SP3) to allow this to happen?
0
Knowledgeable
Asked:
Knowledgeable
4 Solutions
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
No, there is way to do this. In 2003, you must have Exclusive access in order to make design changes to the file. Obviously, Exclusive access would disallow changes from other sources.
0
 
KnowledgeableAuthor Commented:
PLEASE NOTE: This question is NOT a duplicate of the other two questions I have just asked. The other two questions deal with two other customer sites, and this particular question has to do with a completely different (third) customer site. I need all three of these questions to be answered since I need to provide resolutions to the issues that all three of these different customers are having.
0
 
ajkampCommented:
If you want to modify data, then you can have a shared DB. If you want to do development type of work, the answer is no. See the link below for more details.

http://office.microsoft.com/en-us/access-help/about-sharing-an-access-database-on-a-network-mdb-HP005240860.aspx
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Nick67Commented:
As @LSMConsulting noted and as discussed eariler in the week
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_26972048.html
No, there is not.

There are administrative means to work towards the goal of team development but they are complex
See the question noted for some detail on that
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
<This question is NOT a duplicate of the other two questions I have just asked>

I don't see where anyone mentioned other questions - was there some reason you mention this?
0
 
KnowledgeableAuthor Commented:
LSMConsulting, I just posted this since sometimes people think when I ask successive questions that deal with the same topic(s) that I am asking duplicate questions.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:

 Well to put the final nail in this, from A2000 and up, it is impossible for more then one person to make design changes to a DB.

JimD.
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now