Solved

MS ACCESS Project will be opened read-only

Posted on 2010-09-07
6
369 Views
Last Modified: 2012-05-10
I have a client with a Windows XP Pro PC that is running a custom Access project. It is being used by an oil deliver company. When I click on the icon and login to the application, I get this:

"The Microsoft Access project "PLTS" will be opened read-only because one of the files is marked read-only or you specified that you wanted to open this file read-only.

Prior to this, the form opened. Now nothing except the error message. I can then close the application.

I checked the folder and all the files seem to be there.

Everything worked fine up until they lost the internet last week. When it was restored the app stopped working.

I should add that this application looks to the MLS site (multiple listing site) to get its information on people buying and selling homes so that they can download the information into the app and then give the people who have just moved in to the sales people who will call on them to see if they want to have their company provide oil and a service contract.

So perhaps when the app opens it is looking for an internet connection to the site and is not getting it so that it errors out?

And then maybe not.

thanks in advance/
0
Comment
Question by:RSchierer
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 33622549
When you say "project", do you mean an ADP file, or are you using a .mdb file?

With the app closed, look in the folder hosting the database to see if you find a file ending in .ldb. If you do, delete that file - it's the LockFile that Access uses for various things, and if should be removed when access closes. This can sometimes cause your issue.

Also, Compact the database. With 2000 you would open the database and click Tools - Database Utilities - Compact.
0
 

Author Comment

by:RSchierer
ID: 33622674
It is actually a *.ade file, but if memory serves me correctly there was an *.ldb file in amongst the other files. If I delete this file, it should work?

0
 
LVL 84
ID: 33622722
It may. Access creates that file as needed, so you can safely delete it (assuming no one else has that file locked, of course).
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 48

Expert Comment

by:Dale Fye (Access MVP)
ID: 33623185
The other thing you might want to consider is where it was restored from.  If from a CD or DVD, the file is likely read-only.  Check the files properties.
0
 
LVL 75
ID: 33623194
Is there a chance the the file is actually *inside* of a Zip file?

mx
0
 

Author Comment

by:RSchierer
ID: 33623567
The file was not restored from any device or media. My apologies if that is how it came across. One day the office is working fine. The next a switch goes bad and everyone looses internet connectivity. When they get the new switch and everyone is online again, this PC will not run the Access Project with a .ade extention.

Thanks for your input guys.
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
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…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

710 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