Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access thread: Access2000 repairing problem


Message #1 by =?iso-8859-1?Q?Luis_Daniel_Martinez_Calca=F1o?= <luisdanielmc@h...> on Sat, 1 Sep 2001 17:28:48 -0400
Hello,



I have a Access2000 database with about 10 concurrent users and ODBC 

connections to it. My application (developed with Powerbuilder 6.5.1) 

does many queries to the database and it has to be repaired too often, 

about twice a day. I don't know what this problem could be because I 

checked all the source scripts to see if I missed some cursor or 

connection opened which can corrupt the database, but I didn't. The only 

thing that I haved observed is that the "... database has to be 

repaired" message always appears on the slower processor machines. I 

don't know either if this helps you out there but I really would like to 

solve this matter. On the Microsoft site I found that this could be due 

to networking problems but I checked the packages through the network 

with a sniffer and they are just fine, less than 0.01% of error 

packages. Another tip of my ODBC connections is that they are parameter 

default for Microsoft Access databases, maybe I have to change this 

parameters or so to get some stronger connections.



Please help me! I don't know what else to try or do!





Message #2 by "Martha J. Sayers, A.A.B." <marthaj@r...> on Sat, 1 Sep 2001 19:08:34 -0700
Hi,



 Iwas reading your message, and was wondering about the sniffer you used

cause I could use the name of one.

thanks so much   :-)

marthaj@r...




  Return to Index