Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Nov 2002
    Location
    Florida, USA
    Posts
    155
    Thanks
    0
    Thanked 0 Times in 0 Posts

    need advice to save database (Access2000)

    During the Christmas project, the new replica crashed and the only solution I could think of in the middle of work that could not be put on hold was to import all the tables into the front end of the replica. That got us through Christmas but now our working copy of data for the center is not in replica form and the entire database is in one piece. I would appreciate any suggestions for getting the database back in best working order with the least amount of work (remember the development of programs is not actually my job--I teach the classes and am administrator of the services of the center) ah and I forgot to mention that in saving the data; Access did back up the database, but calls the backup by its name and added damaged for me-- this does not make me feel confident. As far as I can tell, the actual data is intact.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: need advice to save database (Access2000)

    Hi Ginger,

    Sorry you've had all this trouble with your database - as you've discovered, replication can be a real savior and at the same time your worst nightmare. And all that in the middle of a Christmas project. <img src=/S/sad.gif border=0 alt=sad width=15 height=15>

    Since you have all the data in the front-end, and in an unreplicated state, you should be able to use the database splitter wizard to create a new back-end and then create a new set of replicas. I'm a little surprised that you got a total crash of the back-end as the more common situation is to have one of the replicas go bad. Is is possible that you have some fairly serious issues with your Local Area Network (LAN)? That seems to be one of the more common areas where Access databases go corrupt.

    Also, you might want to follow a strategy where you keep a specific replica as a backup. In other words, in addition to the replicas that people use to enter or change data, create a replica that is never updated directly, but only updated using replication, and always replicate it from the Design Master. Then if your Design Master does go south for some reason, you make that replica the Design Master, and then recreate the backup replica. If this doesn't make sense, post back and I'll try to amplify. Hope this helps you.
    Wendell

  3. #3
    2 Star Lounger
    Join Date
    Nov 2002
    Location
    Florida, USA
    Posts
    155
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: need advice to save database (Access2000)

    Thanks for your reply, you always seem to be bailing me out. It was not the replica master that failed--BUT it was the only copy that had the day's work in it and there seemed no way to save the data other than to pull it into the frontend and then make a backup. I am using the replica on a LAN with only two computers. Could the LAN be the trouble? I think I can stop using the LAN for direct data input and only update the replica except at Christmas. The amount of data entry during those months is extreme and I dont think we could update often enough to keep up.-- I sure do need a solution. Generally, when children are entered into the Christmas project, the family first has to be added to the whole database (contrary to common belief, most of the children each year are totally new to our center) The data base uses the tables; "family"; "person" and "Christmas" (of whichever year) to run the Christmas project. Two persons are entering data all day long. Usually, one person enters the family and personal data and the other enters the Christmas data-- the Christmas data can be entered as soon as a number is assigned to the child. IF we were to stop having computer #2 enter directly to the one replica; it would slow the process greatly. Once the child is entered, entries are made to that record daily as a sponsor is assigned to the child and as gifts arrive -- are wrapped-- the package tagged and picked up for delivery. Perhaps I should consider not running the center with a replica. Since the backup tagged the backup as damaged-- would you suggest taking all the tables and importing into a totally new database. We have records on over 16000 persons; I would not want to start over building the data from the start [img]/forums/images/smilies/smile.gif[/img]

Posting Permissions

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