If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
On Fri, 5 Nov 2004 06:53:10 -0000, "Nick Coe \(UK\)"
wrote: Lo John, Interesting. BE on a server? I'd have a look at what's actually happening to the BE mdb and ldb files on an OK machine and a problem one with FileMon. http://www.sysinternals.com/ntw2k/source/filemon.shtml Be useful to eliminate any persistant file locks or renegade handles. Probably worth watching the FE too. Is indexing set on the problem machines? Clutching at straws now..... :-) Me too... That's a good idea. I've had NO luck figuring out what it thinks is being updated by what else. I'll see if these tools can tell me... Thanks Nick! John W. Vinson[MVP] Join the online Access Chats Tuesday 11am EDT - Thursday 3:30pm EDT http://community.compuserve.com/msdevapps |
#12
|
|||
|
|||
Might be worth getting the client to send you one of the
system boxes that shows the fault so that you can work on it directly. -- Nick Coe (UK) AccHelp v1.01 Application Help File Builder http://www.alphacos.co.uk/ Download Free Demo Copy ---- "John Vinson" wrote in message ... On Fri, 5 Nov 2004 06:53:10 -0000, "Nick Coe \(UK\)" wrote: Lo John, Interesting. BE on a server? I'd have a look at what's actually happening to the BE mdb and ldb files on an OK machine and a problem one with FileMon. http://www.sysinternals.com/ntw2k/source/filemon.shtml Be useful to eliminate any persistant file locks or renegade handles. Probably worth watching the FE too. Is indexing set on the problem machines? Clutching at straws now..... :-) Me too... That's a good idea. I've had NO luck figuring out what it thinks is being updated by what else. I'll see if these tools can tell me... Thanks Nick! John W. Vinson[MVP] Join the online Access Chats Tuesday 11am EDT - Thursday 3:30pm EDT http://community.compuserve.com/msdevapps |
#13
|
|||
|
|||
"John Vinson" replied in message
... ... I was able to SaveToText but got an error on LoadFromText ("unable to generate output file") so I just imported the form and its subforms. John, the fact that LoadFromText fails bothers me. Peter Miller has been saying for 3 years now that importing a form can simply import the corruption, and this error message is definately associated with corruption (amongst other things). -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. |
#14
|
|||
|
|||
On Fri, 5 Nov 2004 07:53:20 -0000, "Nick Coe \(UK\)"
wrote: Might be worth getting the client to send you one of the system boxes that shows the fault so that you can work on it directly. That's not gonna happen... any more than the SEAACA animal control facility will pay for me to fly down there! g I can work on it over Citrix, and reproduce the fault there. John W. Vinson[MVP] Join the online Access Chats Tuesday 11am EDT - Thursday 3:30pm EDT http://community.compuserve.com/msdevapps |
#15
|
|||
|
|||
Hi John,
Two things really jump out at me from comments elsethread: Number 1: I hadn't done so but it didn't help when I did. I was able to SaveToText but got an error on LoadFromText ("unable to generate output file") so I just imported the form and its subforms. I agree with Allen; that definitely sounds like at least *some* form of corruption. Not being able to LoadFromText is very, very fishy. Can you try something on a backup copy? 1. Delete ALL the code behind this massive form (yes, all of it). 2. Compact the database. 3. Try the SaveAsText and LoadFromText now. Are you able to LoadFromText now or do you still get an error? If you can LoadFromText successfully then it is quite probable the VBA code behind the form has become corrupt. Number 2: The Form that does it consistently is the LEAST used of the major forms. There are three applications. It's an animal shelter database; there are Calls (injured animals, dangerous animals, strays, etc); Impounds (animals picked up to be sheltered); and Licensing. It's the Licensing that's causing the problem. It now happens on EVERY attempt to create a new record - and each time I enter data on a subform, I get *six* of the error message popups. If I then leave the computer alone, I get a new message every few seconds - scores of them if I go off for a while. Messages appearing from nowhere also sounds very weird! Do you have any rogue Timer events running anywhere in this application? -- Jeff Conrad Access Junkie Bend, Oregon "John Vinson" wrote in message ... On Thu, 4 Nov 2004 18:46:14 -0800, "Jeff Conrad" wrote: Hi John, In addition to the things Yoda mentioned here are a couple more things to check: Are all the computers on Service Pack 1 for Access 2003? Some, but not all? I doubt this would be the case, but it way be worth checking to see *exactly* what version of Jet everyone is using. Jet 4.0 SP8 will have a version number of 4.0.8015.0 I'll ask my client to doublecheck. However, a Windows security update (can't remember which one) updated Jet past that number. If everyone has installed Service pack 8 AND all the Windows Updates the Jet version should be 4.0.8618.0. Might be worth checking. Is the problem occurring on every computer for your client or just one (or several)? Several. Thanks! John W. Vinson[MVP] Join the online Access Chats Tuesday 11am EDT - Thursday 3:30pm EDT http://community.compuserve.com/msdevapps |
#16
|
|||
|
|||
"John Vinson" wrote in message
The Form that does it consistantly is the LEAST used of the major forms. There are three applications. It's an animal shelter database; there are Calls (injured animals, dangerous animals, strays, etc); Impounds (animals picked up to be sheltered); and Licensing. It's the Licensing that's causing the problem. It now happens on EVERY attempt to create a new record - and each time I enter data on a subform, I get *six* of the error message popups. If I then leave the computer alone, I get a new message every few seconds - scores of them if I go off for a while. Anything interesting in functions called by conditional formatting? Could there be something going on in conditional formatting that is forcing a record to be saved? -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) |
#17
|
|||
|
|||
On Thu, 4 Nov 2004 20:32:24 -0700, "Albert D. Kallal"
wrote: The places I would look for is there any update code that runs and modifies some data? Any focus changes from sub-form to main form when this error occurs? (and that code uses a sub-form recordset clone?). Yes... and when I took that code out the problem *seems* to have resolved!!! Two bits of code, don't know which did it: - The users want to be able to enter an address (on a subform) without entering a name (on the mainform). I had code to check to see if Parent!ContactID was NULL; if so, it would insert "Unknown" into Parent.LastName and then set Me!ContactID to (the new) Parent!ContactID. - There was another "alert" form, frmComplaintsAtAddress, which displays all prior complaints referencing the entered address. I was requerying that subform in the AfterUpdate event of the Address field. - The third thing I removed was a Me.Dirty = False in the AfterUpdate of the Address Number field (to keep the ComplaintsAtAddress as current as possible). Commenting out these three has - with *limited* testing - apparently resolved the issue. More testing from users tomorrow! Is the practice of using subform recordset clones and/or focus changes deleterious in general? John W. Vinson[MVP] Join the online Access Chats Tuesday 11am EDT - Thursday 3:30pm EDT http://community.compuserve.com/msdevapps |
#18
|
|||
|
|||
John, Did you ever find the solution to the problem? I am having the same
problem with a client database and have tried what seems like everything to fix the issue. Thanks, Billie Cornell "John Vinson" wrote: On Fri, 5 Nov 2004 07:53:20 -0000, "Nick Coe \(UK\)" wrote: Might be worth getting the client to send you one of the system boxes that shows the fault so that you can work on it directly. That's not gonna happen... any more than the SEAACA animal control facility will pay for me to fly down there! g I can work on it over Citrix, and reproduce the fault there. John W. Vinson[MVP] Join the online Access Chats Tuesday 11am EDT - Thursday 3:30pm EDT http://community.compuserve.com/msdevapps |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Bogus Currency Formatting? | r. howell | Running & Setting Up Queries | 1 | September 12th, 2004 01:34 AM |
Excel loading bogus files on startup. Why? | Mike Echo | Worksheet Functions | 2 | January 22nd, 2004 10:53 AM |
O.T. - Bogus MS Patches | RagDyer | Worksheet Functions | 20 | September 23rd, 2003 04:38 PM |