dcsimg


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 5 of 5

Thread: Access database crashes frequently

  1. #1
    Imran Guest

    Access database crashes frequently


    Hello

    I have an access database application with VB at front end. Database has
    almost 60 tables and 100MB in size after compacting. I am using Crystal Reports
    8.0 for reports with UNC path for Database location. Application is installed
    in a Pathology lab and almost 50 users are using it from 25 win 2k professional
    PCs while we have a win 2k server.

    My problem is that the database crashes frequently, and we have to close
    the application from all pcs and then repair it (database). Any body can
    help how could I fix this problem. I am using acess 2000 with DAO.

    Thanks in advance. You may reply me directly at imran1214@yahoo.com or aaimran@hisoftce.com

    Imran

  2. #2
    Bernie Guest

    Re: Access database crashes frequently


    "Imran" <imran1214@yahoo.com> wrote:
    >
    >Hello
    >
    >I have an access database application with VB at front end. Database has
    >almost 60 tables and 100MB in size after compacting. I am using Crystal

    Reports
    >8.0 for reports with UNC path for Database location. Application is installed
    >in a Pathology lab and almost 50 users are using it from 25 win 2k professional
    >PCs while we have a win 2k server.
    >
    >My problem is that the database crashes frequently, and we have to close
    >the application from all pcs and then repair it (database). Any body can
    >help how could I fix this problem. I am using acess 2000 with DAO.
    >
    >Thanks in advance. You may reply me directly at imran1214@yahoo.com or aaimran@hisoftce.com
    >
    >Imran


    Hi,

    You have reached the limit of MSAccess, no doubt. 50 concurrent users on
    a db with the size of 100Mb gives you this kind of problems.

    You could try to break up the db into several MDB's, maybe one per table.
    Then link all those tables into one common MDB that acts a the mainDB for
    the users. This way you don't need to change anything at the client side.

    However, I suggest you migrate to SQL-Server or MSDE as soon as possible.

    Bernie

  3. #3
    imran Guest

    Re: Access database crashes frequently


    "Bernie" <magnus.bernroth@rejlers.se> wrote:
    >
    >"Imran" <imran1214@yahoo.com> wrote:
    >>
    >>Hello
    >>
    >>I have an access database application with VB at front end. Database has
    >>almost 60 tables and 100MB in size after compacting. I am using Crystal

    >Reports
    >>8.0 for reports with UNC path for Database location. Application is installed
    >>in a Pathology lab and almost 50 users are using it from 25 win 2k professional
    >>PCs while we have a win 2k server.
    >>
    >>My problem is that the database crashes frequently, and we have to close
    >>the application from all pcs and then repair it (database). Any body can
    >>help how could I fix this problem. I am using acess 2000 with DAO.
    >>
    >>Thanks in advance. You may reply me directly at imran1214@yahoo.com or

    aaimran@hisoftce.com
    >>
    >>Imran

    >
    >Hi,
    >
    >You have reached the limit of MSAccess, no doubt. 50 concurrent users on
    >a db with the size of 100Mb gives you this kind of problems.
    >
    >You could try to break up the db into several MDB's, maybe one per table.
    >Then link all those tables into one common MDB that acts a the mainDB for
    >the users. This way you don't need to change anything at the client side.
    >
    >However, I suggest you migrate to SQL-Server or MSDE as soon as possible.
    >
    >Bernie


    Hi

    Thanks for your kind help & auggestions. Actually the application is developed
    using dao, so that it is not easy to migrate to sql server & if there is
    still a way to migerate please let me know.

    Thnaks again
    Imran


  4. #4
    Bernie Guest

    Re: Access database crashes frequently


    "imran" <imran1214@yahoo.cim> wrote:
    >
    >"Bernie" <magnus.bernroth@rejlers.se> wrote:
    >>
    >>"Imran" <imran1214@yahoo.com> wrote:
    >>>
    >>>Hello
    >>>
    >>>I have an access database application with VB at front end. Database has
    >>>almost 60 tables and 100MB in size after compacting. I am using Crystal

    >>Reports
    >>>8.0 for reports with UNC path for Database location. Application is installed
    >>>in a Pathology lab and almost 50 users are using it from 25 win 2k professional
    >>>PCs while we have a win 2k server.
    >>>
    >>>My problem is that the database crashes frequently, and we have to close
    >>>the application from all pcs and then repair it (database). Any body can
    >>>help how could I fix this problem. I am using acess 2000 with DAO.
    >>>
    >>>Thanks in advance. You may reply me directly at imran1214@yahoo.com or

    >aaimran@hisoftce.com
    >>>
    >>>Imran

    >>
    >>Hi,
    >>
    >>You have reached the limit of MSAccess, no doubt. 50 concurrent users on
    >>a db with the size of 100Mb gives you this kind of problems.
    >>
    >>You could try to break up the db into several MDB's, maybe one per table.
    >>Then link all those tables into one common MDB that acts a the mainDB for
    >>the users. This way you don't need to change anything at the client side.
    >>
    >>However, I suggest you migrate to SQL-Server or MSDE as soon as possible.
    >>
    >>Bernie

    >
    >Hi
    >
    >Thanks for your kind help & auggestions. Actually the application is developed
    >using dao, so that it is not easy to migrate to sql server & if there is
    >still a way to migerate please let me know.
    >
    >Thnaks again
    >Imran
    >


    Hi,

    You could use MSDE and link the tables to a MDB-dummy as a first shortcut.
    However there are no major problems using DAO to communicate directly to
    MSDE. You don't even have to set up any ODBC-sources if you use a DSN-less
    connection. Here's a sample to do that;

    cnstr = "ODBC;driver={SQL Server};server=myserver;" & _
    "database=mydatabase;uid=myuid;pwd=mypwd;" & _
    "dsn=;" 'This last one is most important!!!

    set cn = en.OpenConnection("", False, False, cnstr)

    This one is from MS KB-article Q147875. However they left out the first 'ODBC;'-part
    in the connectionstring in the article which means that their sample doesn't
    work(!).

    The truth, though, is that the code usually need to to be revised somewhat
    before everything works flawlessly. Often some flags are needed to be add
    when open recordsets (like dbSeeChanges). Not to mention the syntax differencies
    between MSAccess and TSQL. Wildcards needs to be changed as well as all those
    Access-specific functions, like IIf().

    Maybee you should consider to convert to ADO...

    Bernie

  5. #5
    michael Guest

    Re: Access database crashes frequently


    Are you using DAO or ADO. If DAO then I would recommend upgrading the app
    to ADO and use disconnected recordset exclusively. I have similar apps that
    have recently been rewritten with ADO from DAO. Now I never see the .ldb
    file on the server. The data is retrieved or updated and the connection object
    is closed immediately. I have had 0 problems since.

    michael


    "Imran" <imran1214@yahoo.com> wrote:
    >
    >Hello
    >
    >I have an access database application with VB at front end. Database has
    >almost 60 tables and 100MB in size after compacting. I am using Crystal

    Reports
    >8.0 for reports with UNC path for Database location. Application is installed
    >in a Pathology lab and almost 50 users are using it from 25 win 2k professional
    >PCs while we have a win 2k server.
    >
    >My problem is that the database crashes frequently, and we have to close
    >the application from all pcs and then repair it (database). Any body can
    >help how could I fix this problem. I am using acess 2000 with DAO.
    >
    >Thanks in advance. You may reply me directly at imran1214@yahoo.com or aaimran@hisoftce.com
    >
    >Imran



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