Solved

Back end is being converted to read only

Posted on 2014-12-22
4
160 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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
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…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

705 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

20 Experts available now in Live!

Get 1:1 Help Now