Why is Access corrupting & crashing so much??

[Ron V]

I am running an Access 2004 split database. The tables
have been split off into their own database file and they
are linked into the main database file that stores the
Forms, Queries, Reports, etc.

I used the Security Wizard to build different levels of
security and access privileges. The wizard created a
shortcut to the database (which is stored in a Network
folder), and uses a switch to open the database via
the .mdw file which is also stored in the same network
folder.
Here is the target command line:
"C:\Program Files\Microsoft Office\Office10
\MSACCESS.EXE" "\\Network-2\Groups\Advertising DB\Access
DB\Access.mdb" /WRKGRP "\\Network-2\Groups\Advertising
DB\Access DB\Access.mdw" (Certain names have been changed
here for security reasons).

Now I have that same shortcut Starting the database on the
individual users desktops with this command:
"C:\Documents and Settings\username\Desktop\"

I don't understand why this keeps happening, but the
database for no apparent reason would just become
corrupted and would lock everyone else out until I repair
it. It would be ok for a little while and then the
constant corruption would start in again. I can't
pinpoint the problem.
Have I done something wrong with the setup of the security
file or workgroup file? Is there another way that it
should be setup to prevent these corruptions from
happening?

Please help!!!
I am ready to toss this database completely out the window.

Thanks!

Ron
A frustrated designer.

 

[Lynn Trapp]

The most frequent cause of corruption will have something to do with your
network. You may need to get your network specialists to do some testing.
Apart from that, I would suggest you take a look at Tony Toews' excellent
website on MDB Corruption:

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

 

[Joan Wild]

Hi Ron,

I am running an Access 2004 split database. The tables

I used the Security Wizard to build different levels of
security and access privileges. The wizard created a
shortcut to the database (which is stored in a Network
folder), and uses a switch to open the database via
the .mdw file which is also stored in the same network
folder.
Here is the target command line:
"C:\Program Files\Microsoft Office\Office10
\MSACCESS.EXE" "\\Network-2\Groups\Advertising DB\Access
DB\Access.mdb" /WRKGRP "\\Network-2\Groups\Advertising
DB\Access DB\Access.mdw" (Certain names have been changed
here for security reasons).

That's fine (just be sure that the mdb and the mdw don't have the same
name), but you shouldn't have the frontend on the server, with everyone
opening it. You should give each user a copy of the frontend and put it on
their computer.