Access Error When Opening

%3CLINGO-SUB%20id%3D%22lingo-sub-1392229%22%20slang%3D%22en-US%22%3EAccess%20Error%20When%20Opening%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1392229%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20open%20my%20access%20database%20it%20gives%20me%20this%20error%20first%3A%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22access_error1.png%22%20style%3D%22width%3A%20416px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F192001i1C3DA92CF524D210%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22access_error1.png%22%20alt%3D%22access_error1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThen%20it%20gives%20me%20this%20error%3A%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22access_error2.png%22%20style%3D%22width%3A%20484px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F192002iC49DD22C80D155EE%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22access_error2.png%22%20alt%3D%22access_error2.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ELastly%20it%20gives%20me%20this%20error%3A%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22access_error3.png%22%20style%3D%22width%3A%20229px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F192004i5F64B9BA85214524%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22access_error3.png%22%20alt%3D%22access_error3.png%22%20%2F%3E%3C%2FSPAN%3E%3CBR%20%2F%3ECan%20someone%20help%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1392229%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1395401%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20Error%20When%20Opening%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1395401%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F668923%22%20target%3D%22_blank%22%3E%40ExFyaG%3C%2FA%3E%26nbsp%3BDid%20someone%20recently%20move%20(or%20even%20worse%2C%20delete)%20the%20back%20end%20accdb%20to%20which%20this%20Access%20FE%20links%20for%20data%3F%20If%20so%2C%20your%20relinking%20code%20needs%20to%20be%20adjusted%20to%20handle%20that%20change%20and%20provide%20you%20with%20a%20way%20to%20find%20and%20relink%20that%20accdb.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%2C%20and%20I%20really%20hope%20that%20hasn't%20happened%2C%20the%20back%20end%20accdb%20got%20deleted%2C%20you'll%20need%20to%20restore%20the%20most%20recent%20backup%20you%20have.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1396019%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20Error%20When%20Opening%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1396019%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F46682%22%20target%3D%22_blank%22%3E%40George%20Hepworth%3C%2FA%3EI%20got%20given%20the%20.mdb%20file%20with%20the%20task%20of%20fixing%20it%20or%20remaking%20it%2C%20but%20we%20have%20no%20backups%20since%20it%20is%20over%2010%20years%20old...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1396793%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20Error%20When%20Opening%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1396793%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F668923%22%20target%3D%22_blank%22%3E%40ExFyaG%3C%2FA%3E%26nbsp%3BYour%20organization%20has%20been%20using%20the%20same%20relational%20database%20application%20for%20over%2010%20years%20with%20NO%20BACKUPS%3F%20Ouch.%20I%20have%20heard%20horror%20stories%20many%20times%20over%20the%20years%2C%20but%2010%20years%20without%20backups%20has%20to%20be%20close%20to%20the%20most%20painful.%20Hopefully%2C%20though%2C%20the%20data%20is%20safe%20somewhere.%20Ask%20your%20IT%20support%20how%20they%20handle%20backups.%20Maybe%20there%20is%20something%20somewhere%20that%20you%20weren't%20told%20about.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20this%20is%20a%20slightly%20different%20picture%20than%20originally%20presented%20as%20well.%20It%20turns%20out%20this%20is%20not%20really%20%22your%22%20mdb%2C%20but%20one%20someone%20else%20uses%20day-to-day%2C%20correct%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESomeone%20gave%20a%20copy%20and%20asked%20you%20to%20fix%20it.%26nbsp%3B%20You%20have%20a%20copy%20of%20one%20mdb%20%22to%20fix%22.%20What%20is%20wrong%20with%20it%3F%20Is%20it%20just%20this%20problem%20you%20are%20posting%20about%2C%20or%20was%20there%20a%20different%20reason%20for%20giving%20it%20to%20you%20to%20fix%3F%3CBR%20%2F%3E%3CBR%20%2F%3EI'll%20step%20back%20and%20offer%20more%20information.%20This%20is%2C%20no%20doubt%2C%20a%20split%20relational%20database%20application%20consisting%20of%20two%20mdb%20files.%20One%2C%20the%20%22Front%20End%22%2C%20contains%20only%20the%20forms%2C%20reports%2C%20queries%20and%20any%20code--macros%20or%20VBA.%20The%20other%2C%20the%20%22Back%20End%22%2C%20contains%20only%20the%20tables%20with%20the%20data%20in%20them.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20GUESS%20is%20that%20you%20have%20only%20the%20Front%20End%2C%20or%20FE.%20The%20Back%20End%2C%20or%20BE%2C%20is%20located%2C%20I%20hope%2C%20somewhere%20on%20the%20network%2C%20in%20a%20shared%20folder.%20The%20FE%20contains%20code%20that%20re-links%20it%20to%20the%20tables%20in%20that%20BE.%20The%20messages%20you%20are%20getting%20are%20being%20raised%20by%20that%20re-linking%20code.%20That's%20the%20good%20news.%20It's%20not%20an%20error%20in%20the%20database%20application%20itself.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EProperly%20written%20re-linking%20code%20should%20offer%20you%20a%20chance%20to%20find%20the%20BE%20and%20re-link%20to%20it%2C%20is%20cases%20like%20this%20where%20the%20FE%20and%2For%20the%20BE%20have%20been%20moved%20from%20one%20folder%20location%20to%20another.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20a%20manual%20Relinking%20feature%20in%20Access%20that%20will%20allow%20you%20to%20fix%20it%2C%20but%20first%20you%20have%20to%20know%20where%20to%20look%20for%20it.%20Ask%20the%20users.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

When I open my access database it gives me this error first:

 
 

access_error1.png

Then it gives me this error:
access_error2.png

Lastly it gives me this error:
access_error3.png
Can someone help?

3 Replies
Highlighted

@ExFyaG Did someone recently move (or even worse, delete) the back end accdb to which this Access FE links for data? If so, your relinking code needs to be adjusted to handle that change and provide you with a way to find and relink that accdb. 

 

If, and I really hope that hasn't happened, the back end accdb got deleted, you'll need to restore the most recent backup you have.

Highlighted

@George HepworthI got given the .mdb file with the task of fixing it or remaking it, but we have no backups since it is over 10 years old...

 

Highlighted

@ExFyaG Your organization has been using the same relational database application for over 10 years with NO BACKUPS? Ouch. I have heard horror stories many times over the years, but 10 years without backups has to be close to the most painful. Hopefully, though, the data is safe somewhere. Ask your IT support how they handle backups. Maybe there is something somewhere that you weren't told about.

 

But this is a slightly different picture than originally presented as well. It turns out this is not really "your" mdb, but one someone else uses day-to-day, correct?

 

Someone gave a copy and asked you to fix it.  You have a copy of one mdb "to fix". What is wrong with it? Is it just this problem you are posting about, or was there a different reason for giving it to you to fix?

I'll step back and offer more information. This is, no doubt, a split relational database application consisting of two mdb files. One, the "Front End", contains only the forms, reports, queries and any code--macros or VBA. The other, the "Back End", contains only the tables with the data in them.

 

My GUESS is that you have only the Front End, or FE. The Back End, or BE, is located, I hope, somewhere on the network, in a shared folder. The FE contains code that re-links it to the tables in that BE. The messages you are getting are being raised by that re-linking code. That's the good news. It's not an error in the database application itself. 

Properly written re-linking code should offer you a chance to find the BE and re-link to it, is cases like this where the FE and/or the BE have been moved from one folder location to another.

 

There is a manual Relinking feature in Access that will allow you to fix it, but first you have to know where to look for it. Ask the users.