Solved

MS Access database file sharing....

Posted on 2010-09-03
8
378 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
  • 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
 
LVL 22

Expert Comment

by:Rick Hobbs
ID: 33596422
0
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 

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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Creating and Managing Databases with phpMyAdmin in cPanel.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

863 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now