MartyConnelly
martyconnelly at shaw.ca
Wed Nov 23 19:43:16 CST 2005
You can force out Idle Users and also a similar method with a timer and hidden form and a small field in a table can be used to force everyone out with a 5 minute warning Candace Tripp has an example mdb "Detect and Logoff Idle Users" http://www.candace-tripp.com/pages/access_downloads.aspx HOW TO: Detect User Idle Time or Inactivity in Access 2000 http://support.microsoft.com/?id=210297 use Const IDLEMINUTES = 20 (instead of the 1 minute setting shown in the Knowledge Base article), and do not display a message box as shown in the article, since message boxes are modal and this would defeat any attempt to close: Sub IdleTimeDetected(sngExpiredMinutes) 'Dim strMessage As String 'strMessage = "No user activity detected in the last" & vbCrLf 'strMessage = strMessage & sngExpiredMinutes & " minute(s)!" 'MsgBox strMessage, vbInformation, "No Sign of Activity!" Application.Quit acSaveYes End Sub Jim Lawrence wrote: >Hi Pedro: > >One thing you can do is when you get the BE recovered. Check to see how >database is being used. Some of the problems that I had were: > >1. Some users never logged off and just left everything running.... result >in extra exposure and halted backups. >2. One user simply used the off and on button when ending for the day. >3. One of the local IT guys would re-boot the server without getting >everyone logged off. > >I am not suggesting that these are the issues at your site but a similar set >of problems that that physically affect database I/O would continuously >corrupt your BE. > >HTH >Jim > > >-----Original Message----- >From: accessd-bounces at databaseadvisors.com >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Pedro Janssen >Sent: November 23, 2005 2:24 PM >To: Access Developers discussion and problem solving >Subject: Re: [AccessD] error & structure: Please Help!! > >Hi Jim, > >even exporting the tables in a blanc database sometimes didn't work. >In two cases i had to copy and past al the data in tables from backup's. >This is a lot of work. Last time it took me about 5 hours to restore al the >data. > >Pedro Janssen > > > >----- Original Message ----- >From: "Jim Lawrence" <accessd at shaw.ca> >To: "'Access Developers discussion and problem solving'" ><accessd at databaseadvisors.com> >Sent: Wednesday, November 23, 2005 11:03 PM >Subject: Re: [AccessD] error & structure: Please Help!! > > > > >>Hi Pedro: >> >>I have run across similar situations before. Everything will remain sable >>until a station or the server goes down in the middle of a data operation >>between the FE and BE. If this happens often enough, the databases will be >>corrupted. In most cases this database will have to be brought back from >>the >>last night's backup. >> >>The last time this situation happened on a client's site they ended up >>losing two weeks worth of work. From then on I have never used the bound >>database model except for small sites. >> >>You should be able to restore the data, by creating a blank BE and >>exporting >>one table at a time from the old to new. >> >>Jim >> >>-----Original Message----- >>From: accessd-bounces at databaseadvisors.com >>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Pedro Janssen >>Sent: November 23, 2005 11:09 AM >>To: Access Developers discussion and problem solving >>Subject: Re: [AccessD] error & structure: Please Help!! >> >>Hellp Gary, >> >>the backend of the database is on one server. >>The frontends are on the C: drive of about 10 pc's. >> >>To my knowledge there are no network problems. >>I always thought that it could be a problem when more then 1 user is >>working >> >>in the same table, but this is just an idea. >> >>Gary, i will send you the database of line. The error you can find in the >>accessd mail i returned to Scott Marcus. >> >>Thanks >> >>Pedro Janssen >> >> >>----- Original Message ----- >>From: "Gary Kjos" <garykjos at gmail.com> >>To: "Access Developers discussion and problem solving" >><accessd at databaseadvisors.com> >>Sent: Wednesday, November 23, 2005 7:46 PM >>Subject: Re: [AccessD] error & structure: Please Help!! >> >> >> >> >>>Hi Pedro, >>> >>>Do you have other people using this database??? Is it shared over a >>>network?? Do any of the users have any network connectivity issues?? >>>It is my experience that database corruption is almost always caused >>>by a flakey network connection. Fix that and you will fix the real >>>cause of the problem. I don't think you database structure has >>>anything at all to do with the problem. >>> >>>You are welcome to send me your stripped database and I will have a >>>look at it though. You can send it to be at garykjos at gmail.com >>> >>>Gary >>> >>>On 11/23/05, Scott Marcus <marcus at tsstech.com> wrote: >>> >>> >>>>Pedro, >>>> >>>>What is the error? >>>> >>>>Scott Marcus >>>>IT Programmer >>>>TSS Technologies Inc. >>>>www.tss.com >>>> >>>>-----Original Message----- >>>>From: accessd-bounces at databaseadvisors.com >>>>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Pedro Janssen >>>>Sent: Wednesday, November 23, 2005 11:46 AM >>>>To: Access Developers discussion and problem solving >>>>Subject: [AccessD] error & structure: Please Help!! >>>> >>>>Hi, >>>> >>>> is there really no one who can help me with this? >>>> >>>> >>>>Last week i posted an error message, but became no answer that gave me >>>>an >>>>explanation for the error. >>>>Is there someone who could look at the databasestructure ( i will send >>>>the >>>>stripped database ofline) and see why this error can appear, and give me >>>> >>>>some tips to prevent the error and for improvement of the structure. >>>> >>>> >>>>Pedro Janssen >>>> >>>>-- >>>>AccessD mailing list >>>>AccessD at databaseadvisors.com >>>>http://databaseadvisors.com/mailman/listinfo/accessd >>>>Website: http://www.databaseadvisors.com >>>>-- >>>>AccessD mailing list >>>>AccessD at databaseadvisors.com >>>>http://databaseadvisors.com/mailman/listinfo/accessd >>>>Website: http://www.databaseadvisors.com >>>> >>>> >>>> >>>-- >>>Gary Kjos >>>garykjos at gmail.com >>>-- >>>AccessD mailing list >>>AccessD at databaseadvisors.com >>>http://databaseadvisors.com/mailman/listinfo/accessd >>>Website: http://www.databaseadvisors.com >>> >>> >>> >>-- >>AccessD mailing list >>AccessD at databaseadvisors.com >>http://databaseadvisors.com/mailman/listinfo/accessd >>Website: http://www.databaseadvisors.com >> >>-- >>AccessD mailing list >>AccessD at databaseadvisors.com >>http://databaseadvisors.com/mailman/listinfo/accessd >>Website: http://www.databaseadvisors.com >> >> >> > > > -- Marty Connelly Victoria, B.C. Canada