Hello,
I'm having an intermittent problem with the back-end of my database.
On an intermittent basis, the back-end tables will become read-only. This only happens when the back-end is located on a network share.
It isn't a permissions issue because the problem occurs only intermittently when logged in as the same user.
If I open the back-end database on its own and then the front-end client (on the local drive) this problem goes away.
Once the back-end has been made 'read-only', I have to open it on its own and close it again to make the tables editable.
Any ideas?
Jon
15  5576 
I've solved it! I read up on using a persistent connection. Thanks RuralGuy!
I have the database open a hidden form linked to a dummy table in my database. This form is always open in the background, and it's the same as having the back-end database open at the same time.
I still have a minor problem if I close the database and then open it again quickly afterwards; this tends to make the back-end read-only. I guess this might be to do with record locks.
Any idea on how to stop this, perhaps by checking locks on the back-end and waiting if it is being closed at that moment? I wouldn't know how to do this...
You can check for the .ldb file before opening the BE.
Hello again,
The persistent connection seems to have improved performance somewhat, but I still occasionally have the problem with the back-end becoming read-only.
I'm not completely clear about what might be causing this. The only way to make the back-end writeable again is to open the back-end on its own.
Once this database is deployed, this isn't an acceptable solution.
Can anyone help?
I do not understand how the BackEnd can switch to read only if you keep it open with a persistant connection.
Hello again,
Thanks for replying again, RuralGuy.
You're right, it's a weird situation! Since I've implemented the persistent connection, it seems to happen only now when I first open the database (before I did this, it could happen at any moment).
I start up the client (which is located on the local hard disk) and at the bottom of every form it will say 'This recordset is not updateable'.
If I then start up the back-end on its own, the first time I do so it will tell me that the database has been opened as read-only. However, when I then close the back-end, it becomes writeable again and the client works fine (until the back-end spontaneously decides that it's read-only again!)
I'm really pulling my hair out on this one, so any further ideas are much appreciated!
Are you checking for the absense ot the .ldb file before opening the BackEnd?
Hello again,
I wouldn't expect the ldb file to be absent in all cases: the database might have two or three people accessing it simultaneously, which works fine. Another user having the database open doesn't turn the back-end read-only.
The back-end seems to go read-only spontaneously, although it tends to happen when the database is first opened.
I didn't realize this was a multi-user environment. Does everyone have the same persistant connection FrontEnd?
Hi,
Sorry for the late reply - the development has taken a different direction but I've got back to this line now!
Yes, all front-end deployments open a connection to a table in the back-end in a hidden form.
The problem is happening less frequently but it still occasionally rears its head and stops all users from editing the data.
I wonder if you have a flakey NIC somewhere?
Anyone else have any insights? The damn thing reared its ugly head again today!
How are you determining that the BackEnd is read only? Does your system throw an error?
Yes, the status bar at the bottom says 'This recordset is not updatable' and users cannot add new records or edit existing ones.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: David ROBERT |
last post by:
Hello,
I need to read data from a MS Access database.
The program (reader) is installed on a linux box and
is written in python langage.
The database is MS Access 2002 installed on a Win XP box...
|
by: M P |
last post by:
What does this mean? I am accessing an ASP page that queries Access Database
thru fileDSN. I'm using IIS 5.0 Win2K SP4
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
General...
|
by: Michael Meckelein |
last post by:
Hi,
My csharp application access a MS Access database through odbc connection.
Is there a way to compact the Access database after deleting records using
the odbc connection?
|
by: Andrew S. Giles |
last post by:
OK, I am trying to prototype a data import function, and the Data Import
Wizard from Microsoft Access is what we wanted to pattern our importer off of.
How do I get to this wizard inside the...
|
by: Paul M |
last post by:
Hello,
is there any way of reading Microsoft Access Macros via VBA code? Or
better still through VB .net code?
By reading I mean being able to read what the actions are plus any
parameters &...
|
by: klynn |
last post by:
Hi:
I'm having problems reading a Microsoft Access file from my ASP.Net app on a
Windows Server 2003 machine. The error message:
The Microsoft database engine cannot open the file, <my_file>. It...
|
by: shapper |
last post by:
Hello,
I have the tables content and content_localized in a Microsoft Access
database.
I created a Query in my Microsoft Access database named
"content_SELECT":
SELECT...
|
by: reema via AccessMonster.com |
last post by:
Did any one faces any difficulties ,issuess or problems using Microsoft
Access
--
Message posted via http://www.accessmonster.com
|
by: SimYing |
last post by:
Is there any way to read and query data from Microsoft Access?
Actually, i had anapplication which build using Python, wxPython, NumArray and etc. Now i need to find a way to retrieve data from...
|
by: .nLL |
last post by:
Erorr is
---------------------
Microsoft VBScript runtime error '800a0046'
Permission denied
/a.asp, line 3
-----------------------
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
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...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
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...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |
