Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS ACCESS






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Database Suddenly Becomes "Read Only"


I have a database on a network which has no security setup; everyone who has rights to its directory has full rights to the application. From time to time, it becomes "Read Only" and no one can do anything that requires writing to the local tables (the back end database is "Read Only" for everyone.) Checking the database properties shows the database as not being "Read Only" and changing it to read only and back again does nothing.

So far, the only way I have been able to solve this problem is to replace the "Read Only" database with a backup copy that is not "Read Only".

What could be happening here?


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Database Suddenly Read-only
I have a database running for the last 6 or so years (A97) and have the ctl-shift disable enable code in it to stop people tinkering about with it.

The database was aparently working fine yesterday and today it's decided to be read-only so no-one can update the data.

It's on a server - all permissions ok and not read-only.

I can't get the disable/enable code to work either. So basically, it's locked for any development changes and it's locked for any data changes.

The IT boys are going to take a backup from the tapes of the server and re-install it, so it should be ok, but I've never had this happen before and the database is used daily for the last 6 years with no problems.

Any speculative thoughts?

[edit] I have done a search and couldn't find anything that fitted the situation

Thanks

Col

View Replies !   View Related
Access Database Suddenly "Read-Only"
Hello,
I have an Access database that for some reason just converted to "read-only". I used to be able to open the database and do whatever, now it says it is read only. I have checked the permissions for both the database itself and the folder it is in and they both do not have "read-only" selected. What I really don't understand is if I use my application that uses the database (written in ColdFusion) I get the error - must use an updateable query. BUT if I continue to hit refresh, then it'll work! So it's like it works sometimes, but not all the time - as if it's switching back and forth between read-only and not read-only. Does anyone have any suggestions?
Thank you!!

View Replies !   View Related
Read Only Database
Hi, I am trying to create a database from scratch, however I need multiple users to have access to it. I do this nearly everyday and have no issues on the LAN we use.

This week I have been struggling to create a database on a different LAN. I create the database however I get the message that it is read only when I close it and enter it again. This means that other people are also unable to open it at the same time, and when they managae, they only get read only access.

Could this be a strange unfamilar-to-me LAN set up? Or is there something fundamental that I am not doing when creating this database?

Thanks for any help

View Replies !   View Related
Read-only Database?
hello,

You helped me solve my linking issue with my front-end/back-end database, but I've got another question. Whenever I open up the front-end ( the shortcut to it anyway), I can't open it in edit mode- only edit. Even if I do a fileopen and select the type of open I want, it doesn't work. How do I open it in edit mode so I can link the table?

thanks again

View Replies !   View Related
Backup Database Is 'read Only'
Hi All,

I created a database in Access and of course password protected the backend version. As a matter of course I backed up the mdb to cd in case of emergency.

Our network has been taken down due to some virus being bought in by a laptop user so I wanted to reinstall the mdb from the cd to my c: drive.

The problem is that the file is saying that it is 'Read Only' which I think is down to the password protection i put on there.

Question:
Is there a way I can get round the security?

I promise I am not a hacker!

Cheers

Smudger

View Replies !   View Related
Tweaks For Database? Ah...just Read What I Mean!
I would like to tweak my database so that when it opens for the users it will not show the minimize, maxamize, and close buttons at the top. Also, I would need code that will maximize my forms automatically. Let me know if this is not a good idea? I am trying to eliminate someone thinking that the close button will act as a cancel button. I dont want them to save information on accident since access saves automatically! (I already have a close without saving button on every form but people are used to closing document to not save them)

View Replies !   View Related
NOT Read Only Access Database
How do you make an Access database able to have records written to it (NOT read only)?

View Replies !   View Related
Access Database Read-only
I am having problems with ODBC Access data source name. When I want to display some database data in a html table on a webpage there is no problem. But when I send data from a html form to the database I get an OLE DB error. (I am using ADO). I can't remember the message exactly but it was something like

Microsoft OLE DB Provider for ODBC drivers error '80004005'
[Microsoft][ODBC Microsoft Access driver] The command must be execute on a query which can be edited.
insert.asp, line 50

For some reason my database is read-only. And I don't want that. I tried
1. ODBC administrator deleting and creating a fresh System DSN, checked if there Read-Only wasn't marked on.
2. Deleted my browser cache.
3. Restarted computer several times again
4. Installed MDAC 2.8 again.

btw. I have created the table with MS Access XP and i am using Windows XP.
Below is my code.

[code]
<FORM ACTION="insert.asp" METHOD="post">
Barcode: <INPUT TYPE="text" NAME="a1" SIZE="15"><BR>
Artist: <INPUT TYPE="text" NAME="a2" SIZE="40"><BR>
Album: <INPUT TYPE="text" NAME="a3" SIZE="50"><BR>
<INPUT TYPE="submit" VALUE="Send">
<INPUT TYPE="reset" VALUE="Clear"><BR>
</FORM>
<%
a1 = request.Form("a1")
a2 = request.Form("a2")
a3 = request.Form("a3")
if ((a1 <> "") and (a2 <> "")) or ((a1 <> "") and (a3 <> "")) then
Set db=Server.CreateObject("ADODB.Connection")
db.ConnectionTimeout=40
db.Open "DSN=pieter", "admin"
sql = "INSERT INTO albums VALUES ('"&a1& "','"&a2& "','" &a3& "')"
Set rs = Server.CreateObject("ADODB.Recordset")
<----- Here is the error ----> db.execute sql
db.close
Set db=Nothing
end if
%>
[code]

View Replies !   View Related
Quick-save Database To Read-only
Does anybody know if there is a quick way of making a database read-only (so no data input OR design priviledges).

Ive had a request to send somebody a database so they can look at the data but not add/amend etc. The only thing I can think of is adding a security workgroup and assigning read only permissions. But this seems a bit long-winded and I wondered if I was missing something obvious like a 'save as - read only' option.

Any ideas.

Thanks,
Adam.

View Replies !   View Related
How Can I Read A Text File Into A Database
This is what I would like to achieve

Each time a person comes into our building, they use a electronic key. The information is recorded into a text file. I would like to extract information as described next



The date from the line marked D. Date is marked in bold

The time from the line marked T. Time is marked in bold

The key number and Location from the line marked M. Key Number & Location is Marked in Bold



Sample of the text file:



D[ Fri 30/04/04 ]

T[ 08:19 ]

M[ Valid key:130 Ing group, tenancy:SUNCITY, door:Lower Roller Dr, panel:SURF CITY. ]

N[ 0 2 0 0 5 23 1 0 0 0 130 2 ]



D[ Fri 30/04/04 ]

T[ 08:22 ]

M[ Valid key:20 LEAD NGUYANST, tenancy:SUNCITY, shaft:0, panel:SURF CITY. ]

N[ 0 1 0 0 5 16 1 0 0 0 20 2 ]



D[ Fri 30/04/04 ]

T[ 08:23 ]

M[ Valid key:556 Ing Group, tenancy:SUNCITY, door:Lower Roller Dr, panel:SURF CITY. ]

N[ 0 2 0 0 5 23 1 0 0 0 556 2 ]



..and so on the text goes



I am reasonably familiar with access but I have not had any experience with Text Files . Could someone post a sample db that would give me a starting point. any information would be appreciated.



Phil.t

View Replies !   View Related
I Can Read, But Not Write To My ACCESS-database??
I have an access database and some asp-code on my computer which only works one way?
I can read from it, but not write?

...and when I put the asp-code and the database on anohter server it works fine.
..what setting do I have to do, to make it work on my computer?

I have another asp-site with a mySQL-database on my compter which works fine...but
it doesn't work with my access-database...hmm...I can only read from it.

View Replies !   View Related
Error "The Database 'Name' Is Read-only?
Hello,

I have a MS Access 2000 database application stored on a Novell Network server and being shared more than 20 users. However, occasionally, different users, who want to open it in the morning have the error message The database 'Name' is read-only. Therefore, those users can NOT run any action or procedure queries/reports. To resolve, we have to disconnect all the current users, who previously open the database, then everybody can open WITHOUT the "read-only" error!!??

Please advise any permanent solution to avoid the "read-only" issue without disconnect all the users who already open the database?

Thank you so much.

View Replies !   View Related
Cannot Update. Database Or Object Is Read-only - User Rights?!
Hi together.

I have a problem getting this error message "Cannot update. Database or object is read-only" in my Access form application.

The funny thing is, when i run this program under a Administrator account, it's working...but its not working with the User account.

Of course the User hast permission to this folder, it's just a folder on the "C:" drive.

Is there a special right i have to modify that the user can work on it?

thanks

thomas

View Replies !   View Related
Runtime Error 3027 Cannot Update Database Or Object Is Read Only
Hi

I'm having trouble with my database (Access 2000). I'm trying to export a file into a text file by clicking on a button. Below is the code. Where the code is in bold that is when the runtime error happens.

If i export the code manually by right click on the query > Export then this works, but for some reason by clicking on the button will not work.

Private Sub cmdExport_Click()
Dim sExportFilePath As String
sExportFilePath = DLookup("[DateExportLocation]", "tblSettings", "[ID]=1") ' Path if file to be exported
DoCmd.OpenQuery "qryUpDateTransmissionDateAndTime", acViewNormal, acEdit ' Update dates time
DoCmd.TransferText acExportDelim, "ExportFile", "qryExportFile", sExportFilePath
End Sub


I appreciate your help

View Replies !   View Related
Runtime Error 3027 Cannot Update, Database Or Object Is Read-only
I create a front end and back end that resides on the lan. Front has everything besides the table which resides on the back end. Front ends table are linked to the backend. I have two computer that i am testing it on. Both of them runs Access 2003 runtime and windows has been update to the latest version, both xp machine aswell.Both has user right to read and write to that directory on the lan. Ldr exist when either of them uses access file. The strange thing is when i run a command to copy some data from one table to another one. one of the machine give me the following error "3027 Cannot Update. database or object is read only". While on the other machine it runs flawless. Another weird thing is if i modified some values in table by using forms it works great on both so i am a bit clueless where the problems is. its seems my problem is copying from one table to another. i dont have problem modyfing one table. Here is the code i use to that halt my ms access database.


Dim dbs As Database, rsProposal As Recordset, TES As String, stdocname As String, stLinkCriteria As String

TES = Me![TESID]

If TES = DLookup("TESID", "Proposals", "TESID =" & "'" & TES & "'") Then
MsgBox "Proposal Already Exists for TES ID: " & vbCrLf & _
" " & TES, vbOKOnly, "Proposal Already Exists"
GoTo Image264_Click_Exit
Else
If MsgBox("Do You Really Want to Create" & vbCrLf & "a New Proposal for TES ID " & vbCrLf & " " & TES & " ?", 289, "Create New Proposal?") = vbOK Then
Set dbs = CurrentDb
Set rsProposal = dbs.OpenRecordset("Proposals")
With rsProposal
.AddNew
![Long_Desc] = Me![Description]
![Short_Desc] = Me![Opportunity]
![Dest_Site] = Me![Install Site]
![TESID] = Me![TESID]
![End_User] = Me![Contractor/Purchaser Name]
![Date_Due] = Me![Proposal Due Date]
![Date_Completed] = Me![Close Date]
![Status] = Me![Status]
.Update
.Close
Set rsProposal = Nothing
dbs.Close
Set dbs = Nothing
End With
stLinkCriteria = "[TESID] = " & "'" & TES & "'"
stdocname = "Form Prop - Detail"
DoCmd.OpenForm stdocname, , , stLinkCriteria
DoCmd.Close acForm, "Form TES - Detail"
End If
End If

View Replies !   View Related

Copyright 2005-08 www.BigResource.com, All rights reserved