Database read only error......
|
How did this happen, I have been using it fine?
Microsoft views outside interference or illegal interference of a database as a VERY serious security risk to it’s software users and reputation, and
although yours is just storing bird sightings the same software could be storing your medical information for the NHS! As a result updates are continually
being installed on your computer to meet new challenges.
We have not established exactly what is causing SQL to suddenly decide your not looking at your database (Neither have Microsoft), but it can be one
of several things;
1 You install the software on one user account and try to access it on another.
2 The administrator (The kids?!) has taken away your ability to manage databases.
3 You have recently installed another piece of software, which secures all of the databases on your computer as belonging to it.
4 Your computer has automatically downloaded a windows update and this is causing a problem.
5 Your computer is not shut down properly (switched off at wall with the table lamp!) whilst using BTL and the database is left locked.
6 More than one incident of BTL open (not sure about this one)
7 Microsoft have a bug in there security software in either SQL or the operating system.
|
|
Enough, so how do I fix it!
1 Make sure you are logged on to the correct user name account with administrative privileges.
2 If it’s still not working navigate to C:\Program Files\ and find the ‘Tick List Software’ folder.
3 Right click on it and select properties
4 Make sure the ‘Attributes’ box is not ticked as read only, if it is then uncheck it and try BTL again.
5 If it’s not checked then select the ‘Security’ tab at top of properties.
6 Now in the top box called ‘groups or user names’ click on ‘Administrators (Computer name/administrator)’. Look at the text box below called
‘permissions’ and see if all the check boxes are checked apart from the last one ‘Special permissions’.
7 If they are not all checked, click on the ‘Edit’ button, highlight the ‘Administrators (Computer name/administrator)’ again and then click on the ‘Full
Control’ check box in the ‘permissions’ text box, then click ‘Apply’ down the bottom.
8 Now click on ‘Users (Computer name/Users)’ and check the ‘Permissions’ text box do the same as before if they are not all checked and click apply.
9 Close all the boxes and BTL should now work.
10 If BTL still does not work it’s probably because you tried re-installing SQL 10 times, BTL 12 times whilst standing on your head hoping that this time
it will work!
11 If 10 is pretty accurate then Uninstall BTL (yes again), uninstall SQL Server 2005 and then delete the entire BTL folder (you do have a backup don’t
you?). Then re-install BTL as if you had never done so before!
My disclaimer: This is not a bug in bird tick list, it is a bug in the operating system of your computer which will/could affect any database software. Whilst I
have communicated with Microsoft on this problem, sought advice and opinion I cannot be responsible or advise how to make alterations to your
operating system, so carrying out these instructions is entirely your responsibility and not mine! So if the dishwasher fails, it rains tomorrow and the other
half loose there precious photos… it’s not my fault!!!
J
|
|
Ok lets take a look at this problem;
Unhandled exception has occurred in your application. If you click Continue, the application will ignore this error and attempt to continue. If you click Quit,
the application will close immediately.
Failed to update database "C:\PROGRAM FILES\TICK LIST SOFTWARE\BIRD TICK LIST\DATABASE1.MDF" because the database is read
only.
First; don’t worry about this error it's easily sorted if you follow my instructions below, but please read my disclaimer at the bottom before you start!
What does this mean?
Microsoft have for years now allowed users of a machine to have different privileges. When you have more than one user on your computer each user is
allowed to carry out different levels of alterations to the machine. The administrative user should be able to do anything, users who are not administrators
may only be able to read files and not install anything.
Contrary to popular belief there are always more than one user account on a windows setup, even if you have not set the accounts up your self… why? So
that Windows can store settings for when/if you do add a user.
What this error is telling you is that currently you do not have the privileges in your user account to allow you to use the database.
|
