Solved

Back end is being converted to read only

Posted on 2014-12-22
4
164 Views
Last Modified: 2015-01-20
Years ago I wrote a series of programs using MS Access 2007 that are linked to a common back end. Just recently someone else I know has made some enhancements to the programs (I was too busy to do them). He is using MS Access 2010 and has now come across a strange situation. Every now and then (happened twice) his backend database opens as read only.
The issue is
•      Backend opens read only and unable to make it write access.
•      Could not perform Compact and Repair
•      But when copied out of that directory, backend opens properly without read only warning.
•      No .laccdb file exists in the directory

Has anyone come across this before? Any suggestions?
0
Comment
Question by:Rob4077
  • 2
4 Comments
 
LVL 5

Accepted Solution

by:
Leon Kammer earned 250 total points
ID: 40514485
Hi,

I have come across this before with network drives, permissions and trusted locations.
Occasionally, I have even seen an access database go into read only mode for no reason other than somebody was uploading a (rather massive) file to the disk containing the access backend and nobody could access the database, that's when I chose to migrate the backend to SQL Server.

Is the frontend in a trusted location for the user running 2010?
Try opening Access first and then opening the database to see if it opens Read Only?
Running Vista / 7? Run Access as Administrator (Right click - run as administrator).
Check the folder where the database resides and make sure the user has all the necessary permissions
(Read, Write, Delete).

The folder the database is housed in required read / write access for each user (if using SSO).
Normally it is possible to right click on the folder and change permissions, however, this depends on what permissions have been issued by the IT dept.

Cheers

Leon
0
 
LVL 49

Assisted Solution

by:Gustav Brock
Gustav Brock earned 250 total points
ID: 40514617
Sounds like missing rights to that folder. If the user hasn't create rights, the laccdb file cannot be created, and the accdb file will be read-only for all but the first user.

/gustav
0
 

Author Comment

by:Rob4077
ID: 40516026
Hi, thanks for your suggestions.

Initially he too thought that could be permissions issue. But later identified that all other backends in the same location are not read only and working fine. And he checked at the file permissions, they also look good. So certainly it is not permissions issue.

He then did below things. It worked
1.      Opened the readonly backend.
2.      Click SaveAs and saved with a different name
3.      Closed the backend and renamed to different filename
4.      Restored to the db in step 2 with original file name
5.      Backend opened with no warnings for read only.

It is now working, until next time, but we have no idea what causes this random occurrence. Any more suggestions?
0
 

Author Comment

by:Rob4077
ID: 40560928
It hasn't happened again since so I still don't know what the problem is. I will close the question and share the points because you all made valid suggestions
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

839 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