473,322 Members | 1,345 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,322 software developers and data experts.

Force Users to log out.

I have a method in place in my application to force users out. It's a
simple tactic I got from these newsgroups where you create a table
with one record called logout, then check that field with a timer on a
form that doesn't close. If it's checked, it starts a forced logout
sequence.

Works fine 99% of the time (unless somebody is in the middle of a
record update and walks away from their computer for several hours,
but that's a different problem). My only real problem with it is when
the database becomes corrupted. Ever since I converted to A03 from A97
and split the database, I've been getting a lot of corruption
(absolutely zero corruption problems with A97 and monolithic DB
structure, again different problem). Anyway, when the DB becomes
corrupted, I cannot even open the database without getting the
'unrecognized DB format, file is corrupted, do you wish to repair it
now?' window that you can't get around, and which does no good because
you can't repair while people are logged in.

I have LDBView, and can use that to help track down 1 or 2 people with
the grudging aid of my helpdesk, but when its 20 people in different
buildings all over the state that is not really practical. The people
who are still logged in when the corruption occurs can use the DB with
no trouble, so I've got to believe there is a way to update that
logout table and force people out.

Anybody know of a way to force a record update to that logout table
without actually being in the corrupted DB itself?
Feb 11 '08 #1
3 4252
I've been thinking about it, and I wonder if it would be better to
reference an external txt file or something rather than an internal
table. Now the question is, how do I write the code to check a simple
external text file. I suppose I can concoct something up on my own.

Feb 11 '08 #2
ARC
In your close routine, couldn't you just call a docmd.runcommand
acCmdSaveRecord prior to closing out the application?

Or you could write a function in the middle of the close routine that closes
all open forms with the saveyes command. If you need details on this, let me
know.

Good luck!

Andy
<An***********@bcbsmn.comwrote in message
news:c3**********************************@s8g2000p rg.googlegroups.com...
I've been thinking about it, and I wonder if it would be better to
reference an external txt file or something rather than an internal
table. Now the question is, how do I write the code to check a simple
external text file. I suppose I can concoct something up on my own.
Feb 11 '08 #3
An***********@bcbsmn.com wrote:
>I've been thinking about it, and I wonder if it would be better to
reference an external txt file or something rather than an internal
table.
Yes, that's always been my thoughts on this topic.
>Now the question is, how do I write the code to check a simple
external text file. I suppose I can concoct something up on my own.
This could be as simple as looking for the presence of a specific file in the same
folder as the backend. Take a text file, call it something like Corruptions read
me.txt. Put some text inside stating rename the file to something like
DepartNow.txt.

Then in that same timer event just do a dir.

Tony

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Feb 13 '08 #4

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

Similar topics

2
by: Matthew Sims | last post by:
Is it possible to force a download without using the readfile function? My website setup consists of my server that serves the web pages plus a high-speed file server elsewhere on the internet...
1
by: Navin | last post by:
hi, guys i am using the following code to force a file download dialog in asp Response.ContentType = "application/vnd.ms-excel" response.AddHeader "content-disposition","attachment; filename="...
17
by: Geoff Cox | last post by:
Hello, Can I use JavaScript to force a maximised window ? Thanks
2
by: Raquel | last post by:
FORCE APPLICATION command is valid only at the 'instance' level. Why is this so? An instance may contain many databases. So, what command do I give if I want to force applications from a particular...
2
by: S P Arif Sahari Wibowo | last post by:
Hi! Do you know how to put a form's Access-Visual-Basic-code that will force the form to be inserted, while the user has not type anything in the form, without changing focus, selection, etc.? ...
4
by: ronen | last post by:
Hi, There are times when Passport users can sign in, on an ASP.NET site, without being prompted for credentials. This happens, as far as I know, when Passport accounts are stored locally (or...
8
by: Keith H | last post by:
I'm looking for a way to force the user to re-authenticate with their Windows username/password/domain after clicking the submit button on an ASP.NET page. This is for an internal application. ...
20
by: Maurice | last post by:
Hi all, I have an application, designed in Visual Studio 2005, which will run mainly on Windows XP computers. If I run the application on a Windows XP computer having the Windows XP Theme...
3
by: marklawford | last post by:
Connected to BD2 8.2 via JDBC, can we force an application off the database? We know we can use the snapshot functions to get a view over connected users, that works find through a standard SQL...
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: 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: 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: 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.