473,322 Members | 1,614 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,322 software developers and data experts.

Locked out

Hi,

We have been using access for some time to write school reports. What I
have written is pretty amateurish, but it does the job! Recently it has
been falling over an I don't know where to start in locating the problem.
It tells one user that the database is being used exclusively by another
user. When this user comes out, it then says it has been left in a state
where it needs repairing. Usually, it can them be repaired, but sometimes
it even then that it cannot be repaired because it is being used. I can
copy and repair it then, but then acn't even delete the orignal. All I can
do is lock it and hide it and save the new one with a slightly different
name so staff can go on using it.

Any ideas would be appreciated.

Thanks in advance
Nov 13 '05 #1
3 1439
JohnM wrote:
Hi,

We have been using access for some time to write school reports. What I
have written is pretty amateurish, but it does the job! Recently it has
been falling over an I don't know where to start in locating the problem.
It tells one user that the database is being used exclusively by another
user. When this user comes out, it then says it has been left in a state
where it needs repairing. Usually, it can them be repaired, but sometimes
it even then that it cannot be repaired because it is being used. I can
copy and repair it then, but then acn't even delete the orignal. All I can
do is lock it and hide it and save the new one with a slightly different
name so staff can go on using it.

Any ideas would be appreciated.

Thanks in advance

Maybe you need to check the shortcuts on the desktop for all users that
open this database or MSAccess. See if anyone has a /excl in the
command line in the shortcut. If a person has /excl in it, a message
box will inform that operator that the database can't be opened
exclusively but it will open. However, if that person is the first one
in, then other users will not be able to get into it.

Get onto google groups http://groups.google.com, advanced search,
(*Access* for the group) and look for a utility/function to determine
which users are in the system. There was a program for A97 called
LDBView.Exe. There is another one for A2000 onward. Look for topics
along the lines of "view users in application", "view users in
database", etc

The file that appears to be causing the problem is your LDB file. This
fild contacts the locks and users. When all users exit the app, this
ldb file should disappear. As long as one user is in the system, you
will have an LDB file for the database name. You might want to try to
delete it if it exists and you know everybody is out of the app.
Nov 13 '05 #2
From your diescription, I think you have multiple users logging in to the
same front-end or monolithic database. Doing so greatly increases your risk
of database corruption, which seems to be at least one of your problems.

You should split the Tables and Relationships (which will now be called the
"Back End") from the Queries, Forms, Reports, Macros, and Modules (which
will now be called the "Front End"). Give each user a copy of the Front End,
and link the tables in the back end, using the Linked Table Manager or code
that you include.

For other good suggestions on performance and on avoiding corruption, visit
MVP Tony Toews site http://www.granite.ab.ca/accsmstr.htm. It is the best
collection of links and information about using Access in a multiuser
environment that I know about.

Oh, and don't disregard Salad's suggestions.

Larry Linson
Microsoft Access MVP
"JohnM" <jo**@jmawer.demon.co.uk> wrote in message
news:d9*******************@news.demon.co.uk...
Hi,

We have been using access for some time to write school reports. What I
have written is pretty amateurish, but it does the job! Recently it has
been falling over an I don't know where to start in locating the problem.
It tells one user that the database is being used exclusively by another
user. When this user comes out, it then says it has been left in a state
where it needs repairing. Usually, it can them be repaired, but sometimes
it even then that it cannot be repaired because it is being used. I can
copy and repair it then, but then acn't even delete the orignal. All I can do is lock it and hide it and save the new one with a slightly different
name so staff can go on using it.

Any ideas would be appreciated.

Thanks in advance

Nov 13 '05 #3
"JohnM" <jo**@jmawer.demon.co.uk> wrote in message
news:d9*******************@news.demon.co.uk...


We have been using access for some time to write school reports. What I
have written is pretty amateurish, but it does the job! Recently it has
been falling over an I don't know where to start in locating the problem.
It tells one user that the database is being used exclusively by another
user. When this user comes out, it then says it has been left in a state
where it needs repairing. Usually, it can them be repaired, but sometimes
it even then that it cannot be repaired because it is being used. I can
copy and repair it then, but then acn't even delete the orignal. All I
can
do is lock it and hide it and save the new one with a slightly different
name so staff can go on using it.

You can't really fault-find on a production file, ie one that is in use.
Further, you should not share an mdb file, you should split it into a front
and back end and give each user their own copy of the front end (back end =
all data tables, front end = everything except native tables but with linked
tables to the back end).

With the FE/BE configuration, each user gets their own FE linked to the BE.
You have a development copy of the FE which you can deliver to each user
after you make a change. You can also compact/repair etc to your heart's
content because no one but yourself will have access to the development
copy.

Search this group and the on-line help for "split database" if you need more
info.

Good luck.

Keith.
www.keithwilby.com
Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Tech | last post by:
In Visual Basic 6.0, the Locked property of a ComboBox control determined whether the text-box portion of the control could be edited. In Visual Basic ..NET, the Locked property prevents a control...
6
by: DebbieG | last post by:
I have created a database for a client and was told that it was to be a one-user database. Well, you know the next statement ... now they want 3 people to be able to use the database. (FYI, I...
2
by: Ken Durden | last post by:
I'm setting up an interface where clients must perform external locking before calling certain commands. I do this to force them to specify the duration the action they performed must persist...
7
by: Andrea Moro | last post by:
I'm writing my first windows control library. A simple textbox with some numeric facilities. Well, there is a strange thing that happen. I want to add a locked property. As many other property,...
6
by: elake | last post by:
I found this thread about a pst file in Windows being locked and I am having the same issue. ...
8
by: kevin.vaughan | last post by:
Good Afternoon Everyone, Could someone please explain why I can't set the Subform control Visible attribute to False as below? The statement for the locked attributes work but not for the...
6
by: ljstern | last post by:
Hello. I am using MS Access 2003 with XP/pro. I have a form that has the following properties set through the property sheet: form: AllowAdditions = False CartridgeID field: Locked = True ...
1
by: Damjan Malis | last post by:
Hi guys... could anyone please help me with my problem getting mouse cursor position while desktop being locked (WIN + L). MSDN says: "The input desktop must be the current desktop when you...
2
by: Josh Burkard | last post by:
Hello For a alarm-system in our company i want to show a message-window at the users screen while some events, even the users computer (Win XP SP 2 in domain) is locked. How can i show a...
18
by: =?Utf-8?B?VGhlU2lsdmVySGFtbWVy?= | last post by:
Because C# has no native SSH class, I am using SharpSSH. Sometimes, for reasons I do not know, a Connect call will totally lock up the thread and never return. I am sure it has something to do...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
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 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.