Database Corruption - Fed Up

[Vincent]

The company I work for has seen an inordinate amount of Access
database corruption with those users using one or more Vista
computers. We always host the database files on an XP machine, so I
know this could not be the result of the IP v 6 bug. In browsing
posts and the Internet, it does not appear anyone else is experiencing
these issues. I find this extremely unusual considering the frequency
with which we are seeing database corruption. I have posted here
previously to see if anyone could offer some insight into why this
might be happening, but I didn't really receive any substantial
responses. If any Microsoft employee is browsing these newsgroups, or
anyone else might know, does Microsoft offer developer assistance? I
am getting tired of rebuilding corrupted databases and so are our
customers.

Vincent

[lyle fairfield]

Re: Database Corruption - Fed Up

On May 14, 12:30 pm, Vincent <animedrea...@v erizon.netwrote :

     The company I work for has seen an inordinate amount of Access
database corruption with those users using one or more Vista
computers.  We always host the database files on an XP machine, so I
know this could not be the result of the IP v 6 bug.  In browsing
posts and the Internet, it does not appear anyone else is experiencing
these issues.  I find this extremely unusual considering the frequency
with which we are seeing database corruption.  I have posted here
previously to see if anyone could offer some insight into why this
might be happening, but I didn't really receive any substantial
responses.  If any Microsoft employee is browsing these newsgroups, or
anyone else might know, does Microsoft offer developer assistance?  I
am getting tired of rebuilding corrupted databases and so are our
customers.
>
Vincent

I think MS sends different levels of Access to different countries and
regions.

Take me for example. I am pretty sure my clients would say, "Corrupted
Access Database? What's that?" I have been developing with Access for
more than fifteen years, since the early nineties. I have never
experienced a corrupted Access db TTBOMR, although I have downloaded a
few for recovery. Strangely, everyone of those suffered from the same
malaise. They had all died from embarrassment, being huge piles of
almost unintelligible, bloated and convoluted CRAP!

The only thing I can think that explains this is that Bill sends me
superior products. What else could it be?

[Vincent]

Re: Database Corruption - Fed Up

On May 14, 12:47 pm, lyle fairfield <lyle.fairfi... @gmail.comwrote :

On May 14, 12:30 pm, Vincent <animedrea...@v erizon.netwrote :
>

     The company I work for has seen an inordinate amount of Access
database corruption with those users using one or more Vista
computers.  We always host the database files on an XP machine, so I
know this could not be the result of the IP v 6 bug.  In browsing
posts and the Internet, it does not appear anyone else is experiencing
these issues.  I find this extremely unusual considering the frequency
with which we are seeing database corruption.  I have posted here
previously to see if anyone could offer some insight into why this
might be happening, but I didn't really receive any substantial
responses.  If any Microsoft employee is browsing these newsgroups, or
anyone else might know, does Microsoft offer developer assistance?  I
am getting tired of rebuilding corrupted databases and so are our
customers.

>

Vincent

>
I think MS sends different levels of Access to different countries and
regions.
>
Take me for example. I am pretty sure my clients would say, "Corrupted
Access Database? What's that?" I have been developing with Access for
more than fifteen years, since the early nineties. I have never
experienced a corrupted Access db TTBOMR, although I have downloaded a
few for recovery. Strangely, everyone of those suffered from the same
malaise. They had all died from embarrassment, being huge piles of
almost unintelligible, bloated and convoluted CRAP!
>
The only thing I can think that explains this is that Bill sends me
superior products. What else could it be?

Golly Lyle, do you need any help carrying that enormous ego of yours?
Can anyone offer some constructive advice and not use the newsgroup as
a forum for telling us how wonderful they are?

[lyle fairfield]

Re: Database Corruption - Fed Up

How about migrating to SQL-Server?

On May 14, 2:23 pm, Vincent <animedrea...@v erizon.netwrote :

>
Can anyone offer some constructive advice and not use the newsgroup as
a forum for telling us how wonderful they are?

[David W. Fenton]

Re: Database Corruption - Fed Up

There's not enough information in your message to even begin to
diagnose. Have you already gone through all the steps in Tony
Toews's Corruption FAQ?

http://www.granite.ab.ca/access/corruptmdbs.htm

And the most important thing:

Is the app split, with nothing shared except the back end data MDB?

You don't mention what version of Access you're using but I've found
that it's crucial that you use the latest, patched versions of
Access for every version. Almost all the suspect databases I've ever
seen (i.e., reported as in need of repair, but with no actual
corruption) have been from users' Access installations reverting to
less than the patched versions of Access (usually via
re-installation, or rebuilding a workstation, or installing a new
PC, etc.).

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

[PW]

Re: Database Corruption - Fed Up

On Wed, 14 May 2008 09:30:02 -0700 (PDT), Vincent
<animedreamer@v erizon.netwrote :

The company I work for has seen an inordinate amount of Access
>database corruption with those users using one or more Vista
>computers. We always host the database files on an XP machine, so I
>know this could not be the result of the IP v 6 bug. In browsing
>posts and the Internet, it does not appear anyone else is experiencing
>these issues. I find this extremely unusual considering the frequency
>with which we are seeing database corruption. I have posted here
>previously to see if anyone could offer some insight into why this
>might be happening, but I didn't really receive any substantial
>responses. If any Microsoft employee is browsing these newsgroups, or
>anyone else might know, does Microsoft offer developer assistance? I
>am getting tired of rebuilding corrupted databases and so are our
>customers.
>
>Vincent

I found some knowledge base article that explained fax machines and
various other hardware located very close to where the data is stored
can corrupt Access databases. We had a client that constantly (about
every week or so) getting their 97 database and then 2003 corrupted.
They followed the instructions in that article and we rarely hear that
from then any more (if we do, we just have them e-mail us their db and
we do a compact and repair and send it back to them).

HTH.

-pw

[Albert D. Kallal]

Re: Database Corruption - Fed Up


A really great faq on corruption can be found here:

http://www.granite.ab.ca/access/corruptmdbs.htm

The other question asked here is your application split?

After all, virtually every other piece of software you have in your office
has been installed on each personal computer, it would be pretty strange to
break with this precedent just because you're developing software with MS
access in this case.

If your IT people are having a hard time grasping why you must split your
database for reliable operation, I have the following article that not only
*tells* you to split, but explains ***why*** you split in simple terms. You
simply must treat your application part like any other software application
that you install on each workStation.

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

The application part, and the data part should be kept separate. It's
possible in your case that you've already split, but I just want to make
sure you realize that you need to install a copy of your application you
build on each WorkStation, and prevent the application from being dragged
all over the network.

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKa llal@msn.com

[Keith Wilby]

Re: Database Corruption - Fed Up

"Vincent" <animedreamer@v erizon.netwrote in message
news:603751e8-0ab3-4565-9b02-b18ba596ed33@26 g2000hsk.google groups.com...

The company I work for has seen an inordinate amount of Access
database corruption with those users using one or more Vista
computers. We always host the database files on an XP machine, so I
know this could not be the result of the IP v 6 bug. In browsing
posts and the Internet, it does not appear anyone else is experiencing
these issues. I find this extremely unusual considering the frequency
with which we are seeing database corruption. I have posted here
previously to see if anyone could offer some insight into why this
might be happening, but I didn't really receive any substantial
responses. If any Microsoft employee is browsing these newsgroups, or
anyone else might know, does Microsoft offer developer assistance? I
am getting tired of rebuilding corrupted databases and so are our
customers.
>
Vincent

A frequent cause of corruption is multi-users sharing the same mdb file on a
server. You don't say whether or not you've split your apps but if you
haven't then it is a worthwhile exercise.

Here's some more info on splitting:

https://www.granite.ab.ca/access/splitapp/index.htm

Regards,
Keith.

https://www.keithwilby.com

[lyle fairfield]

Re: Database Corruption - Fed Up

Could you post links to your top ten "constructi ve advice" posts,
Vincent? I did a search but they didn't pop up for me.

I'll try to explain my point again. Access/JET corruption is not an
issue on a dependable network with a well-designed database and a well-
crafted application.

PS When you post, including a bit of information about the problem you
identify, is often a good idea.

On May 14, 2:23 pm, Vincent <animedrea...@v erizon.netwrote :

Golly Lyle, do you need any help carrying that enormous ego of yours?
Can anyone offer some constructive advice and not use the newsgroup as
a forum for telling us how wonderful they are?

[Chen Alan]

Re: Database Corruption - Fed Up

Hi,

Do you need to recover your database? If necessary, you may try Advanced
Access Repair at http://www.datanumen.com/aar/ This tool is rather
useful in salvaging damaged Access MDB files and works rather well for
me. Hope this helps.

Alan




*** Sent via Developersdex http://www.developersdex.com ***

[Keith Wilby]

Re: Database Corruption - Fed Up

"Chen Alan" <fyz@datanumen. netwrote in message
news:1210925671 _15764@news.new sfeeds.com...

works rather well for
me.

Is it significant that your link and e-mail address are of the same domain?

[Larry Linson]

Re: Database Corruption - Fed Up

"Keith Wilby" <here@there.com wrote

"Chen Alan" <fuzzy@datanume n.netwrote

>works rather well for me.

Is it significant that your link and e-mail address are of the same

domain?

Alan Chen: "Who, me, spam? Excuse me a moment while I polish my halo."

<SARCASMI suspect it is a completely innocent coincidence. </SARCASM>

[Tony Toews [MVP]]

Re: Database Corruption - Fed Up

PW <paulremove_wil liamson858@remo vehotmail.comwr ote:

>I found some knowledge base article that explained fax machines and
>various other hardware located very close to where the data is stored
>can corrupt Access databases.

Fax machines? Or are you thinking welding machines?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at

http://www.granite.ab.ca/accsmstr.htm

Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

[Tony Toews [MVP]]

Re: Database Corruption - Fed Up

Chen Alan <fyz@datanumen. netwrote:

>Do you need to recover your database? If necessary, you may try Advanced
>Access Repair at http://www.datanumen.com/aar/ This tool is rather
>useful in salvaging damaged Access MDB files and works rather well for
>me. Hope this helps.

You also work for that company. Posting without disclosing any
connection is highly unethical and sleazy.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at

http://www.granite.ab.ca/accsmstr.htm

Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/