473,396 Members | 2,109 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Database went read-only for a day

55
Yesterday (while I was out sick), the Access 2000 database I've been refining and further developing for a company suddenly went read-only for a day. Near as I can tell, it's the backend that went read-only. Everyone could get in through their frontends (which are on each workstation computer), but no one could add or change data.

Today it's working fine.

I'm hoping there's some explanation other than it missed its developer... that's a little too scary to contemplate.

Has anyone else experienced this? Any idea why this might happen?

Angi
May 6 '08 #1
6 1750
puppydogbuddy
1,923 Expert 1GB
Yesterday (while I was out sick), the Access 2000 database I've been refining and further developing for a company suddenly went read-only for a day. Near as I can tell, it's the backend that went read-only. Everyone could get in through their frontends (which are on each workstation computer), but no one could add or change data.

Today it's working fine.

I'm hoping there's some explanation other than it missed its developer... that's a little too scary to contemplate.

Has anyone else experienced this? Any idea why this might happen?

Angi
Angi,
It sounds like a server permissions issue. You need to check with your System Administrator and find out what happens in your absence. Maybe the back end server is not made available until you log-in.
May 6 '08 #2
ADezii
8,834 Expert 8TB
Yesterday (while I was out sick), the Access 2000 database I've been refining and further developing for a company suddenly went read-only for a day. Near as I can tell, it's the backend that went read-only. Everyone could get in through their frontends (which are on each workstation computer), but no one could add or change data.

Today it's working fine.

I'm hoping there's some explanation other than it missed its developer... that's a little too scary to contemplate.

Has anyone else experienced this? Any idea why this might happen?

Angi
To be honest with you, Angi, I have never experienced anything like this before. It does not appear to be Database related, perhaps the Network Administrator doing some work on the File Server where the Back End resides?
May 6 '08 #3
missinglinq
3,532 Expert 2GB
Or maybe, with you gone for the day, everyone spent the day playing Solitare, updating their profiles on eHarmony and just spun you this fairy tale to cover themselves!

Linq ;0)>
May 7 '08 #4
ADezii
8,834 Expert 8TB
Or maybe, with you gone for the day, everyone spent the day playing Solitare, updating their profiles on eHarmony and just spun you this fairy tale to cover themselves!

Linq ;0)>
Yours is the more likely scenario, linq. (LOL).
May 7 '08 #5
angi35
55
Thanks... all plausible answers!

It can't have to do with whether I'm logged in or not, because on a daily basis people are using this database before I get in in the morning. What's more, the backend is on the general server that everyone uses for practically everything. Yet this file was the only thing not working (or so they tell me).

I doubt it has to do with the system administrator doing work on the server, since our system administration is outsourced and the guy only comes on Tuesdays (this happened on a Monday).

So it looks like the Solitaire and eHarmony scenario is indeed the most likely answer.

Hmmmm...

Angi
May 7 '08 #6
Megalog
378 Expert 256MB
I had the same problem for a while, with the monster database I'm in charge of.. Every time I had a day off, it would completely explode, giving error messages to the users that I had never seen before, record lockdowns, all kinds of horrid stuff.

But the minute I get into work, it would be fine. I'd have a pile of printed screenshots on my desk as proof, so I knew at least they werent making it up.
I figured it had grown its own AI and was throwing temper tantrums when daddy wasnt around =)
May 9 '08 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: RobertG | last post by:
Hello I have 2 databases on PostgreSQL, for instance base1, base2. I connect to psql: psql -p 3333 base1 how can I access to base2 ? for instance I wont do instruction: insert into test(a, b)...
49
by: Relaxin | last post by:
It is just me or has MS created some of the worst ways to access and display data? You can use a DataSet, but if you want to sort or filter the data to must use a DataView which is created from...
6
by: Eric Robinson | last post by:
Our database just slowed down radically. Certain queries drive CPU utilization through the roof. This happened once before, and the technican simply dumped the data to disk and then played it back...
2
by: Tom John | last post by:
Hi I have a data access layer that provides static functions between my business logoc and an Access database. The connection string to the database never changes. Currently I carefully open...
10
by: mjf | last post by:
Hello, We made a backup image file for a database on one machine (A), and we restored the database on another machine (B), using the backup image file. Everything went fine. But when we try to...
5
by: HSP | last post by:
hi. i need to restore an old database. The db was backed up using a DLT drive, using 2 volumes. The content for the tapes was copied to file onto Solaris machine using rsh and dd (for backup...
2
by: George | last post by:
Hi all, I am trying to convert to vb.net from VB6 and I am haveing a major problem with connecting to an Access database and adding, updating, deleting data. This is what I usually use in vb6:...
9
by: Jerim79 | last post by:
I am no PHP programmer. At my current job I made it known that I was no PHP programmer during the interview. Still they have given me a script to write with the understanding that it will take me a...
0
by: Israel Carr | last post by:
Thanks for anyone who takes the time to read this. If I posted to the wrong list, I apologize and you can disregard. I need help with a script to pull data from a postgres database. I'm ok...
5
by: Jonathan Wood | last post by:
I have a Web application. Initially, I created a database in the App_Data folder and then attached it to SQL Servero 2005 (not SQL Server Express). I realize now that this is now what I want. So...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.