Do Long Names Corrupt?

  • Thread starter Thread starter good12find
  • Start date Start date
G

good12find

I have an Access 97 database that I've been developing since '98.
All seems to have been fine until about 5 years ago. The database exits or
crashes for no reason. I have been trying to figure this out for years, but
cant seem to identify the cause. I've tried all kinds of tips on corruption
without success.
Recently I was able to reproduce the problem.
I went directly into a design view of a report and the system exited out,
back to my desktop.
The query driving the report had a long name of "Quote Like Status Summary
by Cust". I then changed it to "Quote_Line_Status_Summary_by_Cust".
This seemed to help, but not eliminate the problem. I can now go into the
design view of the report without it crashing. But the system still crashes
on occassion for no apparent reason.
The problem is, my database is built on long names for the objects, reports,
etc.

My question is, are the long names causing my database to crash all the time?

Any insight would be extremely appreciated.
 
Hi Jerry,
Thank you very much. I've acually gone through these and just cant seem to
figure out what is going on.
I'm not sure I get any indications of corruption. The database will just
exit. No warnings, messages, nothing. I then reopen and all is fine.
I'm running a front end / back end database. All on 97.
It worked flawlessly for about 5 years, then out of the blue would crash (or
exit) for no reason. In the meantime I've done the following :
Run on Win2k and XP front ends
Win2k3 server back end OS
Changed hardware, Servers, desktops, routers, hubs, etc.
I also run Peactree - wondered if it conflicts with Btrieve that it uses.
I've created new databases, imported all info over, even converted to text
first, then imported, eliminated all memo fields, use no add-ins, no OLE or
ODBC. Just cant figure it out.
We've just been using it this way for years.
But it is a thorn in my side because there must be a reason for it.
Any other ideas would be greatly appreciated.

I had another thought. I have the backend passwork protected. Would this
be an issue?
 
Password protected shouldn't be an issue.

You've done many of the correct steps including importing into a new
database file and dumping memo fields.

I'd recommend getting your network people to run a sniffer to see if there
are any bad packets being spewed out somewhere. Bad packets can cause
problems.
 
Back
Top