473,327 Members | 2,074 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,327 software developers and data experts.

MS Access 2000 > file locked by another user

Hello,

I set up a database a few months ago and placed it on our company
network. In the beginning, there was no problem opening it, even when
someone else was working in it at that time.

The last fourteen days we encounter an error message: 'file locked by
another user'. I don't seem to recall that I made changes to the
database since let's say Dec 10, 2004.

It is supposed to work for everybody at all time. The database is set
to 'shared'.

What is the problem and how can I fix it?

Thanks for you reply,

Lieve
Nov 13 '05 #1
8 7236
go*******@hotmail.com (Lieve) wrote:
The last fourteen days we encounter an error message: 'file locked by
another user'. I don't seem to recall that I made changes to the
database since let's say Dec 10, 2004.

It is supposed to work for everybody at all time. The database is set
to 'shared'.

What is the problem and how can I fix it?


Hi Lieve.

It's likely to have locked up because of using a single file in a multi-
user environment. You should really split the database and provide each
user with their own 'front end'.

A 'front end' is an mdb file which contains all objects *except* the
tables, a 'back end' is *just* the tables. You would normally have the BE
on a server in a public location and each user would have their own locally
held FE which would be linked to the BE.

Search the help for 'split database' for more info.

HTH - Keith.
www.keithwilby.com
Nov 13 '05 #2
Keith, can you explain more about putting front ends for each user?
Why would you not just split the database and put a shortcut to the one
front end that is created, at each users end?

I ask because I am finishing up a project in the next couple of weeks
and I do plan to research splitting the db for best practices.
Any advice would be appreciated.

Nov 13 '05 #3
"misscrf" <mi*****@yahoo.com> wrote:
Keith, can you explain more about putting front ends for each user?
Why would you not just split the database and put a shortcut to the one
front end that is created, at each users end?

I ask because I am finishing up a project in the next couple of weeks
and I do plan to research splitting the db for best practices.
Any advice would be appreciated.


It is best practice to provide each user with their own FE. Some people
disagree with this and provide only one common FE but I would advise
against this since there is a danger of data corruption. A dedicated FE
also has a performance benefit.

There are a few different methods for providing users with a FE. I find
the simplest solution (assuming all users are on the same network) is to
use a batch file. The users' shortcut would point to the batch file which
would, in turn, copy the FE from a 'public' (read-only) folder to a
prescribed area on their local drive and then open it.

Typically, the batch file code might look something like this:

ECHO OFF
XCOPY "X:\MyPath\Public\MyGUI.mdb" C:\Temp\MyFolder /I
START "MyGUI" /MAX "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
"C:\Temp\MyFolder\MyGUI.mdb" /wrkgrp "X:\MyPath\Public\MyWrkGrp.mdw"

Of course, this assumes that C:\Temp\MyFolder exists but you can ensure it
does by sending all users a hyperlink to another batch file which prepares
their C drive accordingly.

HTH - Keith.
www.keithwilby.com
Nov 13 '05 #4
Why is all of that code needed? I thought that you use the wizard to
split up the db. Why the code for giving each user their own front end?
Can't you just copy it out?

misscrf

It is never too late to become what you could have been ~ George Eliot

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #5
please no spam <pl**********@myworld.com> wrote:
Why is all of that code needed?
*All* that code?
I thought that you use the wizard to
split up the db.
Yes, you can do that, but the code copies the FE as described in my earlier
post. It doesn't do anything in terms of the 'splitting' process, it merely
makes the FE available on the local drive.
Why the code for giving each user their own front end?
Can't you just copy it out?


Yes, you can copy it manually if you wish.
Nov 13 '05 #6
Thanks. I just get scared when I see code. Where does it go? How does
it run? lol

Anyway, I will only have 2-4 users using this app, so I am not worried
about manually copying the frontend out...

misscrf

It is never too late to become what you could have been ~ George Eliot

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #7
"please no spam" <pl**********@myworld.com> wrote
Anyway, I will only have 2-4 users using this app


Not if your db is useful. The Database Corollary to Moore's Law says that
your number of users will double with every feature you add.
Darryl Kerkeslager
Nov 13 '05 #8
Well, I hope that after a while of testing I might be able to sell it (
after a lotttt of testing) but it really is for our hr department to
just enter and report on candidates who apply for jobs. There are only
2-4 people that do that work.
lol

misscrf

It is never too late to become what you could have been ~ George Eliot

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #9

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

Similar topics

4
by: Fabian von Romberg | last post by:
Hi, I have installed Sql Reporting Services on 2 machines, one is WIN 2000 PRO and the other one is WIN 2000 ADV. SERVER. When I try to access a report using the webbrowser, I get the following...
6
by: Peter Frost | last post by:
Please help I don't know if this is possible but what I would really like to do is to use On Error Goto to capture the code that is being executed when an error occurs. Any help would be much...
28
by: Neil Ginsberg | last post by:
I have a client who is using Access 2002/2000 (the database itself is written in 2000), and is considering migrating to Access 2003. Any recommendations on whether Access 2003 is worth the migrate,...
0
by: Andrew Dowding | last post by:
Hi Everybody, I have been looking at problems with my Windows Forms C# application and it's little Jet 4 (Access) database for the last few days. The Windows Forms app implements a facade and...
29
by: Patrick | last post by:
I have the following code, which regardless which works fine and logs to the EventViewer regardless of whether <processModel/> section of machine.config is set to username="SYSTEM" or "machine" ...
5
by: Fabio R. | last post by:
To support a webfarm scenario, I'd like to store a global array (serialized) in a file on a network share. In this array there is a list of pages "locked" by other users so I need to read this...
1
by: dixcyn04 | last post by:
Ok, now I've run into another little hiccup in my application. The ability to update records already in existance. What is bugging me about this, is the code I will submit was what I found on forums...
1
by: antonio.cuartas | last post by:
Hi all, I have an Access 2000 database file on a shared network (windows) drive which should be accessed by several users at the same time. The problem is that although the database is being...
9
by: O | last post by:
I need to do some lookups and updates on some legacy Access 2.0 files (they've from another vendor and I'm not in a position to update them). I was successful using VB6, but I've moved on to VS...
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...
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...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
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
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.