MS Access Multiuser - Corruption?

Author

Corruption?

Weste

2005-04-06, 8:06 pm

We have an Access 97 app split into a FE and BE. The app has been in
existence for about 1 year. Yesterday, we had network problems - the drive
where the BE is located went down several times during the day. The database
is not giving any typical corruption errors like -1517 etc. However, today
fuctions that typically took 30-60 secs to process are now taking 30+
minutes. There have been no code changes.

I imported all the tables from the old database into a new database. The
size of the old database is 43,374 KB and the size of the new database is
47,442 KB. How can the size of the new database be larger? I checked all of
the tables between the 2 databases and they both have the same number of
tables with the same number of records. Could something have happened to the
indexes? Could his be causing our performance problems? I haven't been able
to put the new database on the network since users are in the system. Are
there any tools/utilities I can use to monitor the network traffic to see if
that is causing the slowdown?

Thanks for your help!

Tony Toews

2005-04-06, 8:06 pm

"Weste" <Weste@discussions.microsoft.com> wrote:

>We have an Access 97 app split into a FE and BE. The app has been in
>existence for about 1 year. Yesterday, we had network problems - the drive
>where the BE is located went down several times during the day. The database
>is not giving any typical corruption errors like -1517 etc.

Actually -1517 is not a corruption message.

I've noticed this problem several times when I've added a foreign key
to a table in the backend which was inserted into the middle of a
table. Everything would work fine for days or weeks until the backend
was compacted. Then the FE would puke with the -1517 error whenever
that particular table was accessed. But deleting the link and
recreating the link or compacting the FE made it work again.

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

>However, today
>fuctions that typically took 30-60 secs to process are now taking 30+
>minutes. There have been no code changes.
>
>I imported all the tables from the old database into a new database. The
>size of the old database is 43,374 KB and the size of the new database is
>47,442 KB. How can the size of the new database be larger? I checked all of
>the tables between the 2 databases and they both have the same number of
>tables with the same number of records. Could something have happened to the
>indexes? Could his be causing our performance problems? I haven't been able
>to put the new database on the network since users are in the system. Are
>there any tools/utilities I can use to monitor the network traffic to see if
>that is causing the slowdown?

Presumably you compacted the new database after importing? I have to
ask that question though.

I'm wondering if some indexes got lost in the old MDB. This is
indeed a puzzler.

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

Weste

2005-04-06, 8:06 pm

Yes, the new db was compacted after importing. I was thinking indexes may
have been lost too. Currently we are still using the old database. The
performance was better yesterday. I'm not sure if we should just continue
using the existing db or if I should replace it with a "clean" version -
importing all of the tables into a new mdb.

"Tony Toews" wrote:

> "Weste" <Weste@discussions.microsoft.com> wrote:
>
>
> Actually -1517 is not a corruption message.
>
> I've noticed this problem several times when I've added a foreign key
> to a table in the backend which was inserted into the middle of a
> table. Everything would work fine for days or weeks until the backend
> was compacted. Then the FE would puke with the -1517 error whenever
> that particular table was accessed. But deleting the link and
> recreating the link or compacting the FE made it work again.
>
> http://www.granite.ab.ca/access/reservederror1517.htm
>
>
> Presumably you compacted the new database after importing? I have to
> ask that question though.
>
> I'm wondering if some indexes got lost in the old MDB. This is
> indeed a puzzler.
>
> 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
>

Jörg Ackermann

2005-04-06, 8:06 pm

Hi,

Weste wrote:

> We have an Access 97 app split into a FE and BE. The app has been in
> existence for about 1 year. Yesterday, we had network problems - the
> drive where the BE is located went down several times during the day.
> The database is not giving any typical corruption errors like -1517
> etc. However, today fuctions that typically took 30-60 secs to
> process are now taking 30+ minutes. There have been no code changes.

It doesn't seem to be a corruption message.
Perhaps there is something wrong with the hidden network options
on your machine.

> Are there any
> tools/utilities I can use to monitor the network traffic to see if
> that is causing the slowdown?

http://www.accessdev.de/nda/hiddeno...=secret&lang=en

HTH
--
Jörg Ackermann Microsoft MVP Access, Germany
German Access FAQ: www.donkarl.com

Sponsored Links