Owen, You most likely won't be able to put an eyeball on the corrupt data. Usually non-visible characters are the culprit. How many tables do you have in your Access database? I believe that you said you're running Access 97. If that's so, Access 97 was not real well suited for the web. It could be you've reached some limitations with the engine. Do you have Access 2000 where you could do a conversion? Access 2000 is many times more robust for web apps. It handles simultaneous connections much better, can handle larger tables and more rows - it's just stouter. Try a conversion if you can. That might fix it. Can you talk your mgt. to going to SQL Server? This might be a good time for you to plead your case . . . .
Dave ----- Original Message ----- From: "Owen Leonard" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, February 09, 2002 9:33 PM Subject: RE: Cannot open database > > Chances are (not positive, but highly probable) that the > > newest entry in the database is the culprit. Try, in access > > to delete or > > edit that entry. > > Dave, is the corruption visible in the data? There's a lot of tables in > the main database, so it would be a lot of stuff to sift through. Also: > Why would several different database files be inaccessible? It's highly > unlikely that they were all accessed around the same time. > > -- Owen > ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
