Back end is being converted to read only

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?
LVL 1
Rob4077Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Leon KammerCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Gustav BrockCIOCommented:
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
Rob4077Author Commented:
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
Rob4077Author Commented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.