I have a simple database that is on a desktop that I have a shared folder and have not had issues till now. What would cause it so say, "This database has been opened read-only." Nothing has changed. Only thing my co-worker did was reboot the machine a few days ago.
We have a database on a PC located on our network. The database is located in this computer's shared folder. Another database grabs data from this database occasionally. We're running into a problem where we cannot open the DB located in the shared folder (permissions granted) without it being a read only instance even with no users accessing the DB.
I'm getting the following message in Access and it's causing all kinds of headaches for the user. Any ideas why it's appearing and how to get rid of it?
I have a shared database and at times the database name changes to db1 when somebody is working on it. It doesn't happen all the time or with specific user.
For example if my database name is Incentive.mdb it will automatically change to db1.mdb when its opened and saved.
I have a VB6 project that connects to a Access database. I get a run time error when I try to copy the database as a backup - "You attempted to open a database that is already opened exclusively..."
I need to be able to copy this database while it is still open. How do I work around this?
How can i have multiple people entering data into a database, also there is an excel file that imports the info every few min, if i have that open i cannot enter data into the database. theres going to about 4-5 users plus the excel file.
One of the forms in my database has a calculated text box control. The calculation is conditional, one condition being based on current date. One of the queries display that calculation. If the the form with the calcualted control is not opened before running the query, the calculated control uses the day the form was last opened as the "current date" which is not what I want. I want to do one of two things:
Either: (Preferably): update the form everytime the database is opened, so that the current date is actually the current date and not when the form in question was last opened.
Or: Update the form first before the query in question is run. This is not preferred because, if I use the calculated control in another query or something, I have to have another "update" step.
Code : .OpenDataSource Name:=CurrentProject.FullName, SQLStatement:="SELECT * FROM [qryMailMerge]"
The error (Error has occurred: The database has been placed in a state by user 'Admin' on machine 'W74XXXXXX' that prevents it from being opened or locked) appears in the Word document.
Code: Public Sub CreateWordToPDF(strWordFile As String, strPDFFile As String, strSQL As String) 'Call CreateWordToPDF("C:Doc1.doc", "C:Doc1.pdf", "SELECT * FROM [qryMailMerge]")
Dim objWord As Word.Application Dim docWord As Word.Document 'Open MS Word using early binding. Set objWord = New Word.Application Set docWord = objWord.Documents.Open(strWordFile)
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?
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?
Hi I want to see Which tabel was opened, who and when opened it. And if possible I want to see what is changed. I want to see as I mentioned above as a "log file"
Hi, My question is how do I write a C# application which performs operations on an access database, such as searching and adding records. My problem is the basic how to : how do I connect between the C# file and the access database ?
p.s. I don't know if it's the right place to ask this question, but I also need to present the application in a form like manner. How do I connect between the c# file, the HTML file which consists of the form, and the Database ? Or should I write the form in c# also ?
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 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)
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
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]
I have a FE DB that I have been opening and closing at various times without incident. Now all of a sudden it only opens as READ ONLY. I can't find anyone with a BE open that might be causing this. What will cause this? If I save a copy and then replace the original will I lose my data?
Okay so I created a database inventory. I know I can turn it into a "application" making it a EXE file. I was wondering after that being done could I burn that into a CD? So it would boot from the CD. Pretty make it work like a program application as in word, excel, etc..
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.
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
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.
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.
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?
