Solved

access: cannot open database which is being opened by other pc

Posted on 2010-09-12
12
652 Views
Last Modified: 2012-05-10
on xp pc, I shared access database that was created by access 2007. If I opened it on other pc (win 7) which running access 2010, then I will not be able to open it from xp pc, but the opposite way will work.

the other thing I also noticed that if I edit data on win 7, it will not get saved in database...
0
Comment
Question by:okamon
  • 4
  • 4
  • 3
  • +1
12 Comments
 
LVL 84
ID: 33657862
You must insure that your users have at least Modify permissions on the FOLDER hosting the database.

Does the Windows7 machine network correctly with the XP machine? There have been some reports of problems getting those two platforms to talk.
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 33657869
perhaps locking mechanism is different (the ldb file that is). is this one db that is shared by all? have u thought of splitting it up to front end and backend? frontend is your forms and code and contains tables linked to the backend db (which is data only). Each user has their own copy of the frontend. This might allow you to share the db,

Otherwise it could be the way the db is opened on 2010. Its not open for exclusive lock?
0
 
LVL 84
ID: 33657873
Also, make sure the "other" machine is not opening the database in Exclusive mode. This can be a setting done in Access or can be achieved through the method used when opening the file. It can also happen is a user opens the database in Design mode (or any object in the database).
0
 

Author Comment

by:okamon
ID: 33658198
the share folder is done by the simple share method on xp machine. So by default other user should have modify permission. I do see there is a lock icon on the ldb file. How can I set the mode in access?
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 33658262
how are users currently opening the db, are they using some kind of shortcut?

in msaccess 2010, ms have realised that ribbons is a pile of crap and brought back menus in some form thank god! anyways if you click on File/Options, on the general tab settings for new blank database is 2007? this doesnt matter too much if you could try set it back to 2003
Then in Client Settings, scroll down to Advanced and check the default open mode.
0
 
LVL 1

Expert Comment

by:momo4kids
ID: 33658427
I have had this problem for a couple of years now.  You need to have a front end and a back end database.  Give all users their own front end linked to the common back end.

Since I make modifaction to the front end of my databases, I set up bat files that copy the front end from the server down to the user's PC each time they login.  It's worked like a charm for years.
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 84
ID: 33660866
<So by default other user should have modify permission>

Please don't assume that this is the case, especially when you're talking about a Windows7 machine interacting with an XP machine.  The newsgroups are replete with postings about issues exactly like this, and in a very large portion of those postings the end solution is permissions. Check those permissions, then check them again.

Maybe this will help, if you're having network issues:
http://windows.microsoft.com/en-US/windows7/Networking-home-computers-running-different-versions-of-Windows

I do agree that the best method is splitting the database, but that's not the root cause of your issue. While doing so may help with locking issues on the FE file, you'd still have permission issues on the BE file.

rocki: MS is fully committed to the Ribbons. As they told us at the MVP summit last year: Learn to love 'em, cause they're not going anywhere.
0
 

Author Comment

by:okamon
ID: 33774880
thanks. I will try and update soon
0
 
LVL 65

Accepted Solution

by:
rockiroads earned 300 total points
ID: 33775060
Scott, slowly getting used to ribbons but still find using access 2007 a pain. My answer to get around the ribbons is to use this addin http://www.addintools.com/english/menuoffice/
0
 
LVL 84
ID: 33777358
Yeah, that's a popular addon. I used it myself at first, but once I "got my head around" the ribbons I have no trouble with them.
0
 

Author Comment

by:okamon
ID: 33918147
is there any open source addon like this?
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 33918240
for excel, word and ppt there is a free version (not open source) but doesn't cover msaccess. I assume you want an msaccess one.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
HasData 9 36
MS Access to SQL Conversion - Bit and Yes/No Datatypes 12 46
Exchange 2016 Databse move 5 26
MS Access VBA Print PDF just Current Page 9 10
This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

910 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

21 Experts available now in Live!

Get 1:1 Help Now