Go Premium for a chance to win a PS4. Enter to Win

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

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.  
0
pdixit1977
Asked:
pdixit1977
  • 4
  • 3
1 Solution
 
Rick HobbsRETIREDCommented:
0
 
pdixit1977Author Commented:
but this is for MS Acces 2003 where we have 2007.
0
 
Rick HobbsRETIREDCommented:
Same database access methods.
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
Rick HobbsRETIREDCommented:
0
 
pdixit1977Author Commented:
can we do another way to do this apart of opening database in certain specific way....
0
 
Jeffrey CoachmanCommented:
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
 
Rick HobbsRETIREDCommented:
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
 
pdixit1977Author Commented:
thanks for very quick solution.
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

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