File size jump on exit causing corruption?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hassan Al-Rubaie - 24 Sep 2004 15:42 GMT

Hi I have an Access 2002 mdb on a Netware 5.1 server
being accessed by mostly Windows 2000 machines and a few
Win98se. There is one Windows XP computer that uses this
database and whenever the user exits the file size jumps
about 2-3 megs. The database is about 153 megs in size
coming off of a fresh compact. I know that adding forms,
and changing other data can cause great file size
increases, but the user is just entering records into a
table and then running a report based on that data
entered. The user does do a lot of copy and pasting with
their entry, there was a theory that it could cause file
size increases as well?

Shortly after this user exits we start getting record
deleted & database corruption errors, but not in the same
table that the user works in, they happen in a different
table. The tables are not linked and do not have any
kind of relationship with each other. We have been
compacting at least once a day for the last month in hope
to try to keep it from crashing.

Does anyone have ideas? Any help or suggestions would be
greatly appreciated.

Hassan

Reply to this Message

TomU - 24 Sep 2004 22:25 GMT

Just a guess but I would make sure that all the users have the most resent
version of the Jet DB Engine appropriate for their Windows version. The
update files are available on the mircrosoft web site but I don't have a URL
handy. I search will find the page that has them.

Tom

> Hi I have an Access 2002 mdb on a Netware 5.1 server
> being accessed by mostly Windows 2000 machines and a few
[quoted text clipped - 21 lines]
>
> Hassan

Reply to this Message

Tony Toews - 26 Sep 2004 00:13 GMT

>Just a guess but I would make sure that all the users have the most resent
>version of the Jet DB Engine appropriate for their Windows version. The
>update files are available on the mircrosoft web site but I don't have a URL
>handy.

Agreed. This is the first thing that should be checked.

FWIW Microsoft Access Fixes, Patches and Updates
http://www.granite.ab.ca/access/msfixes.htm

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

Reply to this Message

- 27 Sep 2004 15:46 GMT

Ok, I've made sure that everyone has the most up to date
service pack. Now what should I do? Just wait and see
if I get more corruption, or are there some other
preventative steps that I can take?

Hassan

>-----Original Message-----
>
[quoted text clipped - 16 lines]
>http://www.granite.ab.ca/accsmstr.htm
>.

Reply to this Message

david epsom dot com dot au - 29 Sep 2004 04:45 GMT

Normally when you see a file size change on exit, it
indicates that a file size change notification has been
caught by your file browser. The actual file size
may have changed at any time.

But if there is just one user, the user is probably
working on a local copy of the file, maintained by
the network. The file won't get written back to the
server until the user exits. (To avoid this, you
may be able to mark the file as 'shared' on Netware).

Switching between local use and shared use (which happens
when a second user starts using a file) has been associated
with some problems with some versions of windows, so
you should try to force the setting to 'shared' if you
can.

(david)

> Hi I have an Access 2002 mdb on a Netware 5.1 server
> being accessed by mostly Windows 2000 machines and a few
[quoted text clipped - 21 lines]
>
> Hassan

Reply to this Message