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

back-end being opened in exclusive mode... how?

I have encountered a problem that I am hoping someone can shed some
light on.

I have a multi-user A97 app. All users have a personal front-end MDE
accessing a shared back-end.

There is no specific MDW file for the app as security rules are housed
within the app itself.

On a couple of occasions, different users have launched the app only
to have the back-end opened in exclusive mode, preventing others from
being able to run the app. The absence of an LDB file precludes the
use of LDBViewer to ascertain which user has the back-end locked.

Once the user in question had been identified and exited the app,
multiple users could then launch the app with no problems.

My questions:
* how can this even happen? (i.e., a front-end causing a back-end to
be opened in exclusive mode?)
* is there any way to programatically ensure that a back-end is NOT
accessed in exclusive mode?

Chuck
Nov 12 '05 #1
1 3226
When you re-link, one of the options is 'exclusive'. If you
use the wizard, make sure the checkbox is cleared. If you have
DAO code to relink, use 0 (zero) as the relink option instead
of dao.dbAttachExclusive

To prevent exclusive access, open the BE database, goto security,
SCROLL UP from tables TO DATABASE, and remove the exclusive
access permission from the 'admin' user.
(david)

"Chuck Van Den Corput" <NO*****************@sympatico.ca> wrote in message
news:28********************************@4ax.com...
I have encountered a problem that I am hoping someone can shed some
light on.

I have a multi-user A97 app. All users have a personal front-end MDE
accessing a shared back-end.

There is no specific MDW file for the app as security rules are housed
within the app itself.

On a couple of occasions, different users have launched the app only
to have the back-end opened in exclusive mode, preventing others from
being able to run the app. The absence of an LDB file precludes the
use of LDBViewer to ascertain which user has the back-end locked.

Once the user in question had been identified and exited the app,
multiple users could then launch the app with no problems.

My questions:
* how can this even happen? (i.e., a front-end causing a back-end to
be opened in exclusive mode?)
* is there any way to programatically ensure that a back-end is NOT
accessed in exclusive mode?

Chuck

Nov 12 '05 #2

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

Similar topics

8
by: Ralph Freshour | last post by:
Is it possible to inhibit the browser Back/Fwd buttons via PHP? Thanks...
1
by: Peter D. Dunlap | last post by:
Hello, I realize that this may not be the best place to ask this question, through the application is asp.net. I also realize that questions about disabling the back button are generally met...
4
by: Hypo | last post by:
I added a 'Back' button to my page, and wrote 'OnClick' code something like this: Response.Write("<script>history.go(-" + iDepthIndex.ToString() + ");</script>"); But, it dosnt work! Effect...
6
by: Mark | last post by:
I have two dropdown lists. Both have autopostback set to true. In both dropdowns, when you select an item from the list, it redirects to the Value property of the dropdown. Nothing fancy. ...
29
by: Tom wilson | last post by:
I can't believe this is such an impossibility... I have an asp.net page. It accepts data through on form fields and includes a submit button. The page loads up and you fill out some stuff. ...
5
by: Tom wilson | last post by:
I'm developing an application that is a benefits enrolment website. The benefits can be of any type in any order as stored in a SQL server. On each page is a Back and Next button. At a certain...
7
by: Sridhar | last post by:
Hi, I have a question regarding the Page_Load method and Back Button of Internet explorer. I have created a webform. In that webform I have several Text Boxes. Also I have two buttons. When I...
4
by: bendlam | last post by:
I have a page that contains search criteria and when you click on the search button it causes a post back that populates a dataview on the same page. One of the gridview columns contains a link...
12
by: jim.richardson | last post by:
Hi all, I'd like a page to be excluded from the back button history, that is, when a user hits their browser's back button, it never backs into this particular page. Can anybody please tell...
22
by: Rickster66 | last post by:
As Instructed this is a new thread regarding my original post: "Select Only 10 Columns Going Back" I'm sorry for the late response. I've been gathering up information and carefully with as much...
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
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: 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: 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)...
0
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...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
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

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.