MS Access database file sharing....

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.  
pdixit1977Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Rick HobbsConnect With a Mentor RETIREDCommented:
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
 
Rick HobbsRETIREDCommented:
0
 
pdixit1977Author Commented:
but this is for MS Acces 2003 where we have 2007.
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
Rick HobbsRETIREDCommented:
Same database access methods.
0
 
Rick HobbsRETIREDCommented:
0
 
pdixit1977Author Commented:
can we do another way to do this apart of opening database in certain specific way....
0
 
Jeffrey CoachmanMIS LiasonCommented:
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
 
pdixit1977Author Commented:
thanks for very quick solution.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.