Results 1 to 6 of 6

Thread: Microsoft Access to prevent database corruption

  1. #1
    Join Date
    Jun 2009
    Posts
    321

    Microsoft Access to prevent database corruption

    Hi friends,
    I have recently started with the Microsoft Access. I have done the basic things with it before but now I am using it as my backend for the project. I am making a project in Visual Basic and I want to use the Microsoft Access as the backend for storing the data. But I don't know about an Access as a database. Does Access helps to prevent database corruption.?? Please provide me the detailed information about it.!!

  2. #2
    Join Date
    May 2008
    Posts
    376

    Re: Microsoft Access to prevent database corruption

    Sharing a database file on the network only, instead of dividing the database MS Access, has been found by Microsoft to be the number one cause of database corruption. A common cause of corruption is a network connection dropped when writing to MS Access back-end files. So I would like to suggest you to not the share a database file on the network. If you want to prevent the database corruption with the help of Microsoft Access, then it is better to divide the database. You can split the database into two following parts :
    1. the front-end forms, reports, queries, and data access pages,
    2. the back-end tables containing your data.

  3. #3
    Join Date
    Aug 2006
    Posts
    287

    Re: Microsoft Access to prevent database corruption

    Security data must also be a concern, along with problems of database corruption. Since Microsoft application link file access back-end MS Access file located on a central server, different users can assign different permission levels. You can assign a read-only permission to your database, while assigning others to read and write. The server can be used to grant different permission levels to link MS Access to the network folder. The network or system administrator can set these for you.
    Dimension 1100 (FMY032J) mini-tower
    2.53ghz Intel Pentium 4
    80 gig nfts HDD
    512 RAM
    Main circuit board: Dell 0CF458
    BIOS: Dell A00
    Display: Intel(R) 82865G Graphics Controller [Display adaptor]
    Multimedia: Sound MAX Integrated Digital Audio
    Windows XP Home SP2

  4. #4
    Join Date
    Jul 2006
    Posts
    339

    Re: Microsoft Access to prevent database corruption

    Since the chances of data corruption increases with poor network rewrites also consider the performance issue. The performance of the database will greatly improve the link Microsoft application file access to fund MS Access file containing only the data tables in Access. The reason is that only data is sent over the network. In a shared database that is not divided, the database objects themselves (tables, queries, forms, reports, macros and modules) should be sent through the network, not just data. Hope that you got some hints for preventing the database corruption.

  5. #5
    Join Date
    Aug 2006
    Posts
    181

    Re: Microsoft Access to prevent database corruption

    If you want to avoid the database corruption, then you will have to follow the described things :
    1. You will have to use the Network Cards of good quality. According to me, it would be good to match the manufacturers of all your NICs and also try to use the same brand as the hubs or switches.
    2. Always keep your operating system and device drivers updated. The major reason for crashing the database is the badly written device drivers.
    3. Use the proper and updated anti-virus to keep your system away from the malwares and viruses.
    4. Don’t leave the database open. Leaving the database open increases the possibilities of corruption, so get your users to close their applications.
    QTechnology Ultra-Quiet ATX PSU 460W I MSI K8N Neo4-F I AMD Opteron 144 CABNE0545 2.66Ghz I 2 x 512MB RAM I 380GB Maxtor SATAI Raid0 Hard Drive I 40GB Maxtor IDE Hard Drive I Nvidia GeForce 7900GTX I Win XP Home Service Pack 2 I Soundblaster Xtreme Fidelity Fatal1ty I Mercury Home Theater HT-4500

  6. #6
    Join Date
    Jul 2006
    Posts
    273

    Re: Microsoft Access to prevent database corruption

    Because only the data is sent across the network, record transactions such as database registry edits are completed more quickly. This reduces network traffic and resulting in increased network speed. Upload the entire application (forms, controls, code, etc) locally and using only one link from MS Access to data interface will make your application run faster because the form or report is sitting on the local workstation hard disk to retrieve it saves time over the network.
    (\__/)
    (='.'=) This is Bunny. Copy and paste bunny into your
    (")_(") signatureto help him gain world domination

Similar Threads

  1. NTDS ISAM: Database Corruption
    By BoanHed in forum Small Business Server
    Replies: 3
    Last Post: 03-01-2014, 10:41 AM
  2. How to defend Microsoft Access 2007 database from copying
    By yummy- in forum Windows Software
    Replies: 5
    Last Post: 30-11-2010, 11:22 PM
  3. 64 bit driver of DSN for Microsoft access database
    By arjun rantu in forum Windows Software
    Replies: 4
    Last Post: 30-11-2010, 12:54 AM
  4. Recover a database in Microsoft Access
    By Balamani in forum Windows Software
    Replies: 3
    Last Post: 11-11-2009, 06:56 PM
  5. NTDS ISAM 467 database corruption
    By low40p in forum Active Directory
    Replies: 8
    Last Post: 03-07-2007, 12:52 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,653,605.94277 seconds with 17 queries