Solved

Moving an Access backed db from one Sars Drive to another left the db READ-ONLY

Posted on 2011-09-07
4
209 Views
Last Modified: 2012-05-12
A client moved their back-end db to a new Sars Drive -- same path and whatnot -- now the db is read-only. Any ideas why? They're shut down right now and I am out of my element here.

Thanks for any help.
0
Comment
Question by:Ei0914
  • 2
  • 2
4 Comments
 
LVL 21
ID: 36499926
Users must have read and write permissions to the folder.

Do all users  of the database have full permissions on  the folder?  

0
 

Accepted Solution

by:
Ei0914 earned 0 total points
ID: 36499965
OK Found the solution.

When moving from one share to the other, the ldb file came with -- We checked and there were a couple users still logged in.

Once they got out -- re-logged in -- all was right with the world.

Whew.
0
 

Author Closing Comment

by:Ei0914
ID: 36521444
Our team figured it out. It was a wiley one. Thanks all who took the time to look at this.
0
 
LVL 21
ID: 36500655
That would do it.


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

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
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…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

770 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