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

"Opened Exclusively" message on same machine with 2 of 3 Windows users

I have a database split into front-end, back-end, on a machine running
Windows XP professional (no network, just a single machine). I just
upgraded the database from Access 97 to Access 2000. The machine has 3
users logging into the machine, one of which is the Administrator.

In addition, I have activated the Access security, with the same 3 users (I
won't get into why now - it's a long story).

When I am logged into Windows XP with one of the users (User2), I can get
into the database with no problem using any Access User ID. However, when I
am logged into the machine as the other 2 users, I get the "opened
exclusively by another user" message, no matter which Access User ID I use.
At first I thought this was a Windows XP permission problem, but one of the
Windows IDs that gets the "opened exclusively" message is the Administrator!

So to recap:

Windows User Access User Error Message?

Administrator Admin Yes
Administrator User2 Yes
Administrator User3 Yes
User2 Admin No
User2 User2 No
User2 User3 No
User3 Admin Yes
User3 Admin Yes
User3 Admin Yes

Looking back on things, I think that I upgraded the database while I was
logged in as User2, so it looks like this problem has something to do with
who "owns" the database as far as Windows is concerned. One last note: the
problem seems to be the back-end database, not the front-end.

Does anyone have any ideas? I can't find any KB article that seems to fit
this.

Shannon
Nov 13 '05 #1
1 1706
Check for delete permissions. It looks like you opened
Exclusive (as you need to do to make design changes), and
you were unable to delete the LDB file when you closed the
mdb.

(david)

"Shannon Rotz" <sr***@shaw.ca> wrote in message
news:GMmGc.30713$WB5.9307@pd7tw2no...
I have a database split into front-end, back-end, on a machine running
Windows XP professional (no network, just a single machine). I just
upgraded the database from Access 97 to Access 2000. The machine has 3
users logging into the machine, one of which is the Administrator.

In addition, I have activated the Access security, with the same 3 users (I won't get into why now - it's a long story).

When I am logged into Windows XP with one of the users (User2), I can get
into the database with no problem using any Access User ID. However, when I am logged into the machine as the other 2 users, I get the "opened
exclusively by another user" message, no matter which Access User ID I use. At first I thought this was a Windows XP permission problem, but one of the Windows IDs that gets the "opened exclusively" message is the Administrator!
So to recap:

Windows User Access User Error Message?

Administrator Admin Yes
Administrator User2 Yes
Administrator User3 Yes
User2 Admin No
User2 User2 No
User2 User3 No
User3 Admin Yes
User3 Admin Yes
User3 Admin Yes

Looking back on things, I think that I upgraded the database while I was
logged in as User2, so it looks like this problem has something to do with
who "owns" the database as far as Windows is concerned. One last note: the problem seems to be the back-end database, not the front-end.

Does anyone have any ideas? I can't find any KB article that seems to fit
this.

Shannon

Nov 13 '05 #2

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

Similar topics

1
by: Alvey Sidecast | last post by:
Struggling even more than usual here. I've (nearly) written an XP application but have this problem where I can't delete any records from the table my subform is based on. The message I keep...
2
by: caradhras | last post by:
I've been troubleshooting for a friend's charity. She wants their database accessible from both their PCs (I'll call them A & B), which are on a local network, both running A2K on Windows 98. I...
2
by: genc_ymeri | last post by:
Hi, We are a team of 4 using win2003 server (sp1) in our dev machines and VS2003 for our .Net web app. We did make a copy of our project (located to one "hardwarely old" PC ) to our machines. All...
1
by: Tom Wild | last post by:
Hi I am trying to create a webform that connects to an Access database. If I use the connection string: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Gizmo\Gizmo.mdb" Then the application...
7
by: Simon Verona | last post by:
I have a problem in my application which I believe is due to open handles.. . The symptom that users report is that after they have been using the application for a while, it will randomly just...
5
by: John A Grandy | last post by:
I have a js function that dynamically generates a block of html that includes an anchor tag : <a href="http://www.google.com" target="_blank" /> When the user clicks this link, the new IE6...
169
by: JohnQ | last post by:
(The "C++ Grammer" thread in comp.lang.c++.moderated prompted this post). It would be more than a little bit nice if C++ was much "cleaner" (less complex) so that it wasn't a major world wide...
28
by: darren via AccessMonster.com | last post by:
Hi I've seen details on bypassing macro security with a bat file but has any one incorporated this with Tony Toews FE Updater? If so, I'd appreciate some guidance. As both open the database...
12
by: Jonathan Wood | last post by:
Greetings, I wonder if anyone can help me with this. I have an XP laptop, and a Vista desktop computer. I use the laptop to run software remotely on the desktop using the Remote Desktop...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
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...
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
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...

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.