UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
2 Pages V < 1 2  (Go to first unread post)
   Reply to this topicStart new topic
> Record Collisions When Using Dlookup, Access 2010    
 
   
wbouton
post Feb 22 2018, 06:44 PM
Post#21



Posts: 24
Joined: 20-February 04



Right just the indication that someone else is accessing db. Do you see any problem with the code I posted. Any reason that the backend record is being locked?
This post has been edited by wbouton: Feb 22 2018, 06:46 PM
Go to the top of the page
 
moke123
post Feb 22 2018, 07:00 PM
Post#22



Posts: 1,278
Joined: 26-December 12
From: Western Ma.,L.I.,N.Y.,Jupiter,Fl.



QUOTE
I can see the DB lock file being created and then deleted over and over again as each user requests a new copy of the message.

Establishing a persistent connection would probably be a good idea.
This post has been edited by moke123: Feb 22 2018, 07:03 PM
Go to the top of the page
 
wbouton
post Feb 22 2018, 07:20 PM
Post#23



Posts: 24
Joined: 20-February 04



Is there any limit on the number of simultaneous connections?
Go to the top of the page
 
moke123
post Feb 23 2018, 05:54 AM
Post#24



Posts: 1,278
Joined: 26-December 12
From: Western Ma.,L.I.,N.Y.,Jupiter,Fl.



QUOTE
Is there any limit on the number of simultaneous connections?

In theory 255 but many would argue more and many would argue less.
You also need to factor in the quality of the network and the quality of the application.
Go to the top of the page
 
LPurvis
post Feb 23 2018, 10:41 AM
Post#25


UtterAccess Editor
Posts: 16,271
Joined: 27-June 06
From: England (North East / South Yorks)


Hi

PMFJI

The absolute limit is 255 concurrent connections. However, in practice it will be considerably less. What you perceive as a single connection to the database may actually be more than one.
Regardless, the error you receive in such a case should reflect that.
But what that would mean is:
a) a persistent connection likely isn't the best idea in your particular case
b) an Access backend really isn't the platform for you

A query request via DLookup or a query (or a DLookup on a query - which really isn't any different) is just that however you slice it.
While it's not inconceivable that you could be encountering Read Locks not being released in time, there's almost not editing going on as I understand it (bearing in mind that you surely can't be anywhere near the conceptual 255 concurrent users).
You could try dropping the IdleFrequency default in the Registry (on each user's PC :-s), but surely even if that worked, it'd be bandaid at most (and a pain to implement).

The query you're using this DLookup upon, what is its definition? Though I can't see how that would affect this, it sounds like you're just asking a bit much.

Cheers

--------------------
Go to the top of the page
 
wbouton
post Feb 23 2018, 10:44 PM
Post#26



Posts: 24
Joined: 20-February 04



I'm just querying a simple one record table with one field. The field is text 255 characters with about 500 users querying over 30 seconds. About 17 users per second.
This post has been edited by wbouton: Feb 23 2018, 10:46 PM
Go to the top of the page
 
wbouton
post Feb 23 2018, 10:48 PM
Post#27



Posts: 24
Joined: 20-February 04



Is there anything else i could do that wouldn't result in this record lock failure?
Go to the top of the page
 
moke123
post Feb 24 2018, 01:01 AM
Post#28



Posts: 1,278
Joined: 26-December 12
From: Western Ma.,L.I.,N.Y.,Jupiter,Fl.



Have you tried any other containers for the message other than an accdb?
how about something like a simple html file and display it in a web browser control?

edit: in re-reading your post you indicate this is a scrolling message which is easily implemented in html.
This post has been edited by moke123: Feb 24 2018, 01:41 AM
Go to the top of the page
 
zaxbat
post Feb 24 2018, 05:55 AM
Post#29



Posts: 934
Joined: 26-January 06
From: .....the wiregrass (either you know or you don't)


Have you considered that the bottleneck may be the hardware of the machine holding the record....are you sure it can keep up with the demand 17 times per second nonstop all day?

--------------------
Kindest regards, and Cheers!
ZAX

A picture is worth a thousand words and a zipped DB is worth a thousand pictures.
Oh, and....please don't disappear into the Twilight Zone.... Holler back with your results!
Go to the top of the page
 
wbouton
post Feb 24 2018, 09:39 PM
Post#30



Posts: 24
Joined: 20-February 04



Fantastic idea regarding HTML. I will Implement on Monday and see how that goes. Thanks for the idea.
Go to the top of the page
 
wbouton
post Feb 26 2018, 08:07 PM
Post#31



Posts: 24
Joined: 20-February 04



Just to let you know calling HTML file for instant message worked like a charm. Thanks for all the help.
Go to the top of the page
 
2 Pages V < 1 2


Custom Search
RSSSearch   Top   Lo-Fi    21st June 2018 - 02:31 PM