Corruption Posts

{Too Long!}

Posted to MB Topic: Offshoring Discussion « AmericanIT Board

{Too Long!}

Posted to MB Topic: Paradox Tables « Paradox Board

{Too Long!}

Posted to MB Topic: Paradox Tables « Paradox Board

{Too Long!}

Posted to MB Topic: Access VBA Programming « Access Board

I have been having a tough time with BLOB (Binary Large Object) errors in memo fields of some large tables running on a Win2008 R2 Terminal server with just 3 users.  Any one else have experience with this? This is an app that has been running with support and modification for 25 years. It has been running on this server for close to 8 years. It is only accessed via a terminal server session, all activity in paradox is native to the server. I have had the tables get corrupted 7 or 8 times in the last three weeks.  I have seen this probably 3 or four times before in the last 8 years, but a rebuild of the tables has resolved it.  In the last three weeks, I have not been able to go more than a couple of days without corruption. I'll post more detail later, I wanted to get this up to see if others have experience with blob errors and figure out if this is the right Prestwood board to post it on as opposed to something specific to coding or tables. Thanks

Posted to MB Topic: Paradox Setup, Vista, etc. « Paradox Board

Database with 14K entries is back up to a corrupted database with loss of data. Repair shows no corruption. Working currently on Vista (Vista issues clear). Trying to open the blob files contents to rebuild the original deletes individual blob field contents permanently (leaving record and revisiting or closing file and reopening shows the records accessed without their stored objects). I keep hoping someone has an idea about this. it is most likely connected to the original issue of file corruption with disappearance of multiple blob entries. (about four hundred at last count). Exporting the file to a different folder and attempting to access the contents in the exported file = same results.,

Posted to MB Topic: Paradox Tables « Paradox Board

I have an mdb file that appears to have some corruption.  I have run the "compact and repair database" utility several times.  This utility runs without reporting any problems.  However, there are about 5 forms of about 60 in the mdb file that, when modified cause MSAccess to crash.  I have also tried to start with a blank mdb file and cutting and pasting every form, table, query, report, from the old file to the new file and the same problem occurrs with the same forms. I am desperately hoping for some advice from somebody to hopefully help me save all the code that I have done and not have to build it again to get rid of the problems (it would really be a pain).  Thanks in advance.

Posted to MB Topic: Access VBA Programming « Access Board

{Too Long!}

Posted to MB Topic: Paradox Setup, Vista, etc. « Paradox Board

{Too Long!}

Posted to MB Topic: Paradox Tables « Paradox Board

{Too Long!}

Posted to MB Topic: Paradox Tables « Paradox Board

Can anybody help with extracting memo field information in preperation to exp[ort to Excel., , I ran a structured query using several tables and got my answer. Included are several memo fields that detail out findings, conclusions, etc. for a record. However, our analysts does not use paradox and needs the data in Excel., , I am aware that an Excel cell will most likely trim the memo field to say 256, but thats OK., , I prefer to not use object code as our system is locked down to prevent data corruption with spurious code. Mike P., I am sure you are aware of our data issues working with Dan., , Regards,, Bill

Posted to MB Topic: Paradox Forms « Paradox Board

I told a client of ours who is having trouble with Paradox table corruption to skip Verify and just perform a rebuild. , , Does anyone recall some of the items Verify checks on?

Posted to MB Topic: Paradox Tables « Paradox Board

I'm wondering if I need to use Referential Integrity (RI) on my new database. It contains about eight tables linked together in a form via the data model tool. It is on a network and has multiple users. There are several 1:M and 1:1 relationships set up on the data model., , The question is, if I don't allow users to access tables directly (using runtime) and they always use this form with the relationships all set up, is there some reason I should also setup RI?, , My main reason for not wanting to use RI is that I have heard thet it may more easily cause table corruption., , Thank you,, , Bruce

Posted to MB Topic: Paradox Forms « Paradox Board

We seem to have a reoccurring problem at just one of our client's offices. There are two tables (both have a key field) that have become corrupt about once a month for the past three months. We have successfully repaired the tables by using the table repair utility. Both of these tables are used heavily on a daily basis. Each time our research has shown that the time stamps of the original .db & it's .px file are out of sync. What would cause this? Our suspicions are network connectivity issues, however, how do you prove this sort of thing? We're considering removing the key field in order to eliminate the .px's but I'm not sure if that'll do the trick., , Background info: Paradox 10 application being used on Windows NT systems., , Any suggestions?

Posted to MB Topic: Paradox Tables « Paradox Board

Request help with a problem that has experts stumped. My database was corrupted when the server went down while building some queries. When the server came back up and I opened the database, it gave me the option to repair it, telling me something had corrupted the database. When I chose that repair option, once the database opened, every query had disappeared. They were able to restore the database from the server from the night before the corruption, however, every time I tried to open a query, no matter which one, I got the message 'anyqueryname isn't an index in this table, look in the Indexes collection of the TableDef object to determine the valid index names'. Would appreciate any help, thanks!

Posted to MB Topic: MS Access Interactive « Access Board

{Too Long!}

Posted to MB Topic: Paradox to/from Other Data Sources « Paradox Board