Results 1 to 3 of 3

Thread: Database Corruption Again

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Jul 2000
    Location
    Manchester NH
    Posts
    833
    Twice in the last two months I have received a "the database could not be opened, it might now even be a database."

    or something like that.

    I DB has become a multi-user from multiple-apps

    clearly, its me because it keeps happening.


    Do I need a real DB engine??

    I am using the MSJet right now and an Access DB


    any input would be great
    Kurt Simons
    [I know I'm a hack but my clients don't!]

  2. #2
    Hyperactive Member tumblingdown's Avatar
    Join Date
    Mar 2000
    Posts
    362
    more details...

    how many users?
    how many apps?
    how many concurrent connections?
    bandwidth useage?
    how much data our we talking about?
    do you have budget to move to other platforms (sybase/sql server) ?
    platform/network?

    "One logical slip and an entire scientific edifice comes tumbling down." - Robert M. Pirsig


    tumblingdown@hotmail.com

    "but if Einstein is right and God is in the details, reality requires that we sometimes get religion." - Scott Meyers.

  3. #3

    Thread Starter
    Fanatic Member
    Join Date
    Jul 2000
    Location
    Manchester NH
    Posts
    833
    Ok,


    ----

    NT network, local network, bandwidth not an issue
    no budget (but what could be done with be appreciated)
    database consists of about 6,000 records in the main table
    about 20 columns of misc data DB size about 1 GB (recently compacted)

    what I get that error I run a repair an all is fine.

    ----

    It started with two apps that both maintaining 1 connection apiece.

    then it grew into 4

    then I added a VB CGI that a few others use.
    with CGI creates a new database connecdtion each time a web page is requested. example:

    set db = dbeninge.opendatabase("\\computeer01\db.mdb")
    set rs =

    SQL

    rs.close
    db.close
    set rs = nothing
    set db = nothing


    ---------------------------------
    if there a disadvantage to opening a db like this or should I be using a FILE DSN or something.

    When it is time for a db engine like sql server. What makes SQL server such a great engine over something like what I have done.


    Answer all you like!

    thanks
    kurt


    [Edited by kurtsimons on 10-18-2000 at 11:12 AM]
    Kurt Simons
    [I know I'm a hack but my clients don't!]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width