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

Access 2003 will not allow design access to db with no one logged on

I have a split Access 2003 database that has operated normally in this regard until now. It has been in use for 4 years and contains 44,000 records in the main table.

I ask all users to log off and then I open the backend and make changes as needed. Today, I needed to delete a corrupt record. I copied the database first. Using the copy as a test, I ran compact/repair and then was able to delete the record.

When I attempted the same process on the original of the database, I could not run compact/repair. An error message stated "You attempted to open a database that is already opened exclusively by user 'Admin'... The computer referenced is the one I am using. I checked and made sure I did not have Access open in any other instance. How do I convince Access that I am the only user logged onto the system? I checked and made sure no other users were logged on. I only have the one instance of the Access database open.
Nov 22 '13 #1
5 1066
Seth Schrock
2,965 Expert 2GB
I get this occasionally when I try to create a backup of the database in Access 2010. All I have to do is close and reopen the database and it works. I normally get it when I have had it open all day without doing much to it.
Nov 22 '13 #2
zmbd
5,501 Expert Mod 4TB
Yep, the other thing I've had to do is simply re-boot the computer as when I've check in the running tasks there will sometimes be a rogue Access program still running in the background.
There is a lock file that Access creates that sometimes doesn't clear too so let us know if this worked for you.
Nov 26 '13 #3
ADezii
8,834 Expert 8TB
As indicated by zmbd, Access creates a Locking File containg specific information whenever a DB is opened. This File should automatically be deleted when the DB is closed, but this is not always the case. Look for a *.ldb (Access 2003) File in the same Directory as the Database. If it does exist, and the Back End is closed and all Users are Logged Off, DELETE it.
Nov 26 '13 #4
zmbd
5,501 Expert Mod 4TB
ADezii
I'm leary about just deleteding the lock file without rebooting the PC first, I've had data corruption.

On our network when this happened, I'd ask everyone to log out of their workstation while I watched the locking file and occationally it would close itself when the user logged out and yet didn't have the front-end open. Strange things I tell you ... strange things in that lake!
Nov 26 '13 #5
I too have experienced the problem referenced. I don't know the ramifications of deleting the 'Lock File' when it may still be needed; but my system won't allow me to delete the hanging 'Lock File' unless all users are logged out. I frequently find the problem is someone left their Windows Profile logged onto a Computer Workstation with the database opened, then switched users. So this makes it appear all instances of the database are closed (as all employees at the available computer workstations have reported they closed their instance of the database) when if fact there is still an instance of the database opened somewhere. We then have to go around to each computer and restart it till the 'Lock File' is automatically deleted (most often the case) or it is released and allowed to delete.

I once started (but never finished) designing a table/coding that logs opening the database then deletes that record when the user exits. I figured this would be of great use to know which User and on which Computer still has an instance of the database opened. We could then easily zero in on the source of this problem.

Logging the opening or closing of the database wasn't the problem I struggled with, but rather identifying the appropriate record to delete (using fields of: Date, Time, winUser, Computer, Open/Closed) particularly involving date changes as our operations are 24 hours a day, and the graveyard starts on one date then finishes on the next. I could be overthinking this and a solution may be much simpler.
Dec 2 '13 #6

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

Similar topics

7
by: Wayne Aprato | last post by:
I have several Access 2003 mde databases. When I try to open them in Access 2002 I get the following error: "The Visual Basic for Applications project in the database is corrupt." ...
1
by: Matt Alanzo | last post by:
On another newsgroup an Access knowledgable party posted: >You should be able to connect an Access ADP to an existing SQLExpress >database running in SQLS 2000 compatibility mode. The only thing...
3
by: Richard W Collens | last post by:
Hey folks! Before I spend any money on Access 2003, is it co-habitable with Office XP? Also, can I use the XP Developers Edition to package and deploy and Access 2003 project? Thanks in...
10
by: Lauren Wilson | last post by:
Ok I have searched the MS website for info on this. I am totally confused. If I want to deploy an Access 2003 app and allow my users to run it using Access 2003 Runtime, where do I get the...
4
by: martin | last post by:
Can anyone please help. I have a main membership form/table that has a subform with function table linked. This is obviously a fixed solution but I would like to make it more dynamic with a combo...
49
by: Mell via AccessMonster.com | last post by:
I created databases on Access 2003 and I want to deploy them to users. My code was also done using 2003. If they have Ms Access 2000 or higher, will they be able to use these dbs with all code,...
2
by: Susan Bricker | last post by:
I have an db that was developed in Access 2003, but it was formated as Access 2000. The person who will be using the db is planning on getting a copy of ms/access 2007. Should we anticipate...
9
by: Al Dykes | last post by:
I have inherited an application written in Access that is a replicated copy from the PC that was used to develop the app. When we had both PCs, we synced the DB nightly. The master PC is gone....
3
by: Bruce | last post by:
I have a number of Access 2000 format databases on a Windows 2003 server. For some reason I can no longer compact these databases directly on the server using Access 2003. Access 2000 seems to...
5
by: Lysander | last post by:
My collegue had to buy a new laptop that came with Office 2007 already installed. She had Access 2003 installed on top, in a different directory. None of our 2003 databases will run on her...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
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...
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...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
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
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
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.