db corruption

[David]

I have had many DB corruptions in the past, but may have
it fixed. I have multiple users (20) on a corp network.
From reviewing many posts and books, I have developed this
process. Can you tell me if the is the correct order in
which to do these things to minimize DB corruption.

Start with 1 MDB file - appox 30 forms and 30 queries and
a handfull of tables.

Compact and repair DB
Compile Code
Compact and repair DB
Split DB
Compact and repair FE and BE DB
Create MDE file
User's copy the MDE file from the server to their desktop.
Compact and repair BE DB daily.


Some of this may be overkill, but if there is something
out a whack, please let me know.

Thank you for reviewing.
David

 

['69 Camaro]

Hi, David.

You've certainly done your homework. You don't mention which version of
Access you and your users are using, but if it's Access 97 or earlier, then
you may want to go lightly on the "repairs." For more information on
compacting and repairing your database and avoiding corruptions, please see
this Web page:

http://www.Access.QBuilt.com/html/gem_tips.html#Compacting

Pay special attention to the section "Don't compact from across a network"
to avoid occasional database corruptions when compacting the database file
on the network shared directory from a workstation.

Make sure that all users have the most recent service packs on Microsoft
Office, Jet, and MDAC. Also make sure that if your server is Windows 2000
Server, then oplocks is disabled.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[David]

Thank you Gunny for the links and tips.

I am using Access 2002 and the users have Access Runtime
2002. Very solid and fast network connectivity, so I
feel I can safely compact and repair from a remote
computer after 5pm.

The server is hundreds of GB's with many many users. I
have no idea if the server is win 2000 or Win NT. Just
in case, would the network/system admin be able to
disable oplocks for a specific folder or file or program?

Yes I have tried to do my homework before posting, and
can proudly say I create some fine databases. But it all
started in the Access Newsgroups. I can't thank folks
enough for spending their free time drugging through
posts just to help someone.

THANK YOU.

 

['69 Camaro]

Hi, David.

I can't thank folks
enough for spending their free time drugging through
posts just to help someone.

You're welcome. It's very nice to be appreciated, especially since there's
no paycheck involved!

would the network/system admin be able to
disable oplocks for a specific folder or file or program?

AFAIK it's all or nothing, because it's a single Registry entry to
enable/disable it for the local machine and a single Registry entry to
enable/disable requests for it from the Windows client to the remote
machine. See this Web page for more information:

http://support.microsoft.com/default.aspx?scid=296264

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)