Sign in
 
Home20132010Other VersionsLibraryForumsGallery
TechCenter >
> 
> 
Issue opening Access 2000 file

Answered Issue opening Access 2000 file

  • Friday, June 22, 2012 5:04 PM
     
     
    Sign In to Vote
    0
    I am trying to open a access file from microsoft 2000 and this message keeps coming up (The Microsoft jet database engine stopped the process because you and another user are attempting to change the same data at the same time) This file is on a USB stick and no one else is trying to open it.  Can someone tell me step by step how this can be fixed?
     

All Replies

  • Friday, June 22, 2012 5:16 PM
     
     
    Sign In to Vote
    0

    You should never open a document, workbook, database, ... on a USB stick directly. Always copy the file to hard disk, edit it there, then copy it back.

    The caching mechanism used by USB sticks interferes with editing.

    Regards, Hans Vogelaar

     
  • Sunday, June 24, 2012 3:18 PM
     
     
    Sign In to Vote
    0
    Hi I appreciate your answer, however I have tried both ways and the same thing keeps happening.  So it is not opening the file off the USB stick because it does the same on hard disk.  Really hope you can help.  Thanks again..
     
  • Sunday, June 24, 2012 3:27 PM
     
     
    Sign In to Vote
    0
    What happens if you hold down the Shift key while opening the database? This should bypass the startup options of the database (if any).

    Regards, Hans Vogelaar

     
  • Sunday, June 24, 2012 4:40 PM
     
     
    Sign In to Vote
    0
    I just tried that and get same message and will not open..
     
  • Sunday, June 24, 2012 4:46 PM
     
     Answered
    Sign In to Vote
    0

    It looks like the database has become corrupt.

    I'd create a blank new database, and try to import all database objects (tables, queries, forms, ...) from the problem database into the new one.

    It that succeeds, you'll have to do the following to be able to use the new database instead of the old one:

    • Set the startup options the same way as in the old one (Tools | Startup...)
    • If you have VBA code that uses non-standard references, set those references in the new database (Tools | References... in the Visual Basic Editor).

    Regards, Hans Vogelaar