Solved

MS Access database file sharing....

Posted on 2010-09-03
8
403 Views
Last Modified: 2013-11-29
Hi,
Few days back our OPS team has created a database in MS Access 2007 (.accdb).
Now only 1 user is able to open that and other not where we need to have multiple users working on the same database file.
I m not very much familiar with MS Access so please help on this.  
0
Comment
Question by:pdixit1977
[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
  • 4
  • 3
8 Comments
 
LVL 22

Expert Comment

by:Rick Hobbs
ID: 33596253
0
 

Author Comment

by:pdixit1977
ID: 33596307
but this is for MS Acces 2003 where we have 2007.
0
 
LVL 22

Expert Comment

by:Rick Hobbs
ID: 33596329
Same database access methods.
0
Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

 
LVL 22

Expert Comment

by:Rick Hobbs
ID: 33596422
0
 

Author Comment

by:pdixit1977
ID: 33597272
can we do another way to do this apart of opening database in certain specific way....
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 33598663
First, the Database should be split.
http://www.databasedev.co.uk/split_a_database.html

Second, is that if the database is in the 2007 format, it will only be readable by users who have Access 2007 installed.
(So users who have only Access 2003 (.mdb) or older installed, will not be able to open the Acc 2007 (.accdb) Database.

Can you tell us specifically what happens when a user cannot open the file?
Nothing, Error message, system crash, ...etc?

;-)

JeffCoachman
0
 
LVL 22

Accepted Solution

by:
Rick Hobbs earned 125 total points
ID: 33601011
This should help if you want to open differently.  Shows you how to change default database open method.  Should be similar in access 2007.

http://www.databasedev.co.uk/multi-user-applications.html
0
 

Author Closing Comment

by:pdixit1977
ID: 33619882
thanks for very quick solution.
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

734 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