Re: Why is Access corrupting & crashing so much??

From: Lynn Trapp (ltrappNoSpam_at_ltcomputerdesigns.com)
Date: 04/26/04 

Date: Mon, 26 Apr 2004 12:46:16 -0500

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 

-- 
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
"Ron V" <anonymous@discussions.microsoft.com> wrote in message
news:44e301c42bab$4ce14450$a401280a@phx.gbl...
> 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.

Relevant Pages

  • RE: system.mdw netowrk issue
    ... this is unrelated to the permissions on the network drive, ... >Microsoft Security Bulletin MS03-026? ... >| Both the database, and the MDW file reside in a shared ...
    (microsoft.public.access.security)
  • Re: File Corruption
    ... No one in the 3 institutions have access to their PC's hard drives. ... The "My Documents" is actually a spot on a network drive called the H ... This is probably the most common cause of corruption. ... There is never any valid excuse not to split a database. ...
    (microsoft.public.access.gettingstarted)
  • Re: Corrupt Access File
    ... Also I'm trying to figure out how to back-up on a transaction to transaction ... table everyday and have usually 7-10 users on the network signed in but only ... Jet database files in Word or other applications that automatically save the ... the corruption, and checking the file size would be one of the last things ...
    (microsoft.public.access.formscoding)
  • Re: File Corruption
    ... No one in the 3 institutions have access to their PC's hard drives. ... This is probably the most common cause of corruption. ... There is never any valid excuse not to split a database. ... single shared copy of a front end on a network, ...
    (microsoft.public.access.gettingstarted)
  • Re: Replication/Sychronization and security
    ... > require security because it contains medical data. ... > network with folder level security and the network has a very slow ... Replication is not for solving application performance issues. ... > database to decrease the potential for breach. ...
    (microsoft.public.access.replication)
Quantcast