Will we be sorry we used an .mdb?


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 8 of 8

Thread: Will we be sorry we used an .mdb?

  1. #1
    Join Date
    Oct 2005
    Location
    Simi Valley, CA, USA
    Posts
    7

    Will we be sorry we used an .mdb?

    We're using an Access .mdb for our enterprise.

    Are we going to be sorry we used an .mdb down the road when it has gotten large?

    I keep hearing horror stories about large databases made in Access suddenly becoming irretrievably corrupted.

    thanks.
    Sentry Password Protection Solution - Turns any site into a membership website - Full PayPal Subscriptions IPN support - Sentrylogin.com

  2. #2
    Join Date
    Dec 2003
    Posts
    2,750
    Well Access can be a bit more high maintenance, especially if you're using it in a shared network environment. But I guess it really depends upon how you are going to be using it. For example, will it be used on a network share? Multi-user? Number of concurrent users expected?

    You may want to review the following article:

    http://support.microsoft.com/default...b;en-us;303528
    Paul
    ~~~~
    Microsoft MVP (Visual Basic)

  3. #3
    Join Date
    Sep 2004
    Posts
    9
    Hi There,

    If you are going to use Access, you need also to consider the amount of concurrent connections. As far as I remember, which is version 97 of Access, you are limited to 64. In SQL Server 6.5, you could have, if I am not mistaking, up to 5000 simultaneous database connections. Also, in SQL Server, you can, or could, have a license per server, which is suitable for clusters of SQL Servers, for high-end or connection-demanding internet applications.

    Tonci.

    "I am on my way of making it... Big Time!!"

  4. #4
    Join Date
    Mar 2005
    Posts
    7
    After archiving more than five years of sales history (approximately two million records) into an Access 97 database on our shared network, the database recently approached the maximum file size (800+ KB). Although corruption never occurred, performance degradation was an issue. In order to reduce the file size and increase performance, we exported a few of the larger tables to separate database files and established linked tables to access the data. This fix will suffice until we migrate the data to SQL Server.

    Access is acceptable for small business and personal use where massive archiving is not required. With regular maintenance (record purging and compacting) Access can probably handle most small business database needs.

    Specifications for Access are as follows:

    Access 97
    ---------
    Concurrent connections: 255
    Maximum files size: 1 GB (less overhead)

    Access 2000/2002/2003(XP)
    -------------------------
    Concurrent connections: 255
    Maximum files size: 2 GB (less overhead)

    (see http://office.microsoft.com/en-us/as...868081033.aspx for more information)

    Hope this helps,


    Gorthog
    --You will be assimilated. Resistance is futile.

  5. #5
    Join Date
    Oct 2005
    Location
    Simi Valley, CA, USA
    Posts
    7
    Thanks, all. Do you have recommendations, code, etc. on how to perform purging?
    Sentry Password Protection Solution - Turns any site into a membership website - Full PayPal Subscriptions IPN support - Sentrylogin.com

  6. #6
    Join Date
    Dec 2003
    Posts
    2,750
    You can use the CompactDatabase method supported by DAO and ADO (JRO).
    Paul
    ~~~~
    Microsoft MVP (Visual Basic)

  7. #7
    Join Date
    Nov 2005
    Posts
    2

    Post

    The nice thing about Access MDB is that the info can be Exported to other formats like (the old plain text format) Text (fields separated by commas), and transferred to a new db format with ease.

    database recently approached the maximum file size (800+ KB)
    I've been using MS Access 97 SR2 OEM for approx 2-1/2 years, with only up to 2 people accessing the "MainDB" at any giving time and it is over 14.3 MB in size. And we've had no problems.
    But there are other smaller MDBs that may access info off other MDBs and the "MainDB" on occassion (breaking up the workload).

  8. #8
    Join Date
    Mar 2005
    Posts
    7
    maximum file size (800+ KB)
    sorry, that should have read: 800+ MB

Similar Threads

  1. How to run sub in .MDB from VB using ADO?
    By Bo Alexander in forum VB Classic
    Replies: 5
    Last Post: 10-30-2008, 07:57 AM
  2. .mdb file access
    By Johannes in forum VB Classic
    Replies: 1
    Last Post: 11-01-2002, 03:29 PM
  3. Distribute .mdb with app
    By Johannes in forum VB Classic
    Replies: 2
    Last Post: 07-29-2002, 09:40 AM
  4. How to compact .mdb and get feedback
    By SY Kim in forum VB Classic
    Replies: 10
    Last Post: 05-01-2002, 02:11 PM
  5. Accessing a MS Access .mdb file
    By Anil kumar in forum VB Classic
    Replies: 1
    Last Post: 03-22-2001, 10:39 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center