Access issue on other PC's

%3CLINGO-SUB%20id%3D%22lingo-sub-2026773%22%20slang%3D%22en-US%22%3EAccess%20issue%20on%20other%20PC's%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2026773%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20created%20a%20database%20for%20my%20workflow%2C%20i%20have%20done%20a%20few%20databases%20and%20never%20had%20this%20problem%20before.%3C%2FP%3E%3CP%3EIssue%3A%26nbsp%3B%3C%2FP%3E%3CP%3Ewhen%20i%20try%20to%20open%20it%20on%20another%20PC%20running%20the%20same%20version%20of%20access%20the%20forms%20are%20not%20opening%20and%20crash%20the%20application.%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20i%20open%20the%20form%20in%20design%20view%20then%20save%20and%20view%20it%20opens%20fine%2C%20then%20continues%20to%20work%20fine%20after%20that%20also.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eif%20i%20then%20open%20the%20same%20file%20on%20the%20original%20pc%20i%20built%20it%20on%20i%20don't%20have%20any%20issues%20at%20all.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help%20as%20i%20have%20numerous%20pc's%20that%20the%20application%20will%20run%20on%20and%20having%20to%20open%20each%20form%20in%20design%20view%20to%20get%20them%20to%20work%20seems%20stupid%20and%20not%20practical%20if%20i%20make%20any%20changes%20to%20the%20database.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENote%3A%20i%20have%20a%20front%20and%20back%20end%20database%2C%20tried%20using%20the%20unsplit%20database%20still%20the%20same.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2026773%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2027273%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20issue%20on%20other%20PC's%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2027273%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F915908%22%20target%3D%22_blank%22%3E%40Chris_Oakes_365%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOne%20possible%20reason%20is%20that%20there%20is%20some%20corruption%20in%20that%20one%20or%20more%20forms%20are%20corrupted.%3C%2FP%3E%3CP%3EStart%20with%20a%20compact%20and%20repair%20in%20the%20accdb.%20If%20that%20doesn't%20clear%20up%20the%20problem%2C%20the%20next%20trouble-shooting%20step%20might%20be%20to%20create%20a%20new%2C%20clean%20accdb%20and%20import%20objects%20into%20it%20from%20this%20one.%20Test%20as%20you%20go%20to%20ensure%20that%20each%20form%20imported%20works%20properly%20before%20importing%20the%20next.%20See%20if%20you%20can%20identify%20the%20culprit%20that%20way.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi

 

I have created a database for my workflow, i have done a few databases and never had this problem before.

Issue: 

when i try to open it on another PC running the same version of access the forms are not opening and crash the application. 

If i open the form in design view then save and view it opens fine, then continues to work fine after that also.

 

if i then open the same file on the original pc i built it on i don't have any issues at all. 

 

Please help as i have numerous pc's that the application will run on and having to open each form in design view to get them to work seems stupid and not practical if i make any changes to the database.

 

Note: i have a front and back end database, tried using the unsplit database still the same.

 

 

3 Replies

@Chris_Oakes_365 

One possible reason is that there is some corruption in that one or more forms are corrupted.

Start with a compact and repair in the accdb. If that doesn't clear up the problem, the next trouble-shooting step might be to create a new, clean accdb and import objects into it from this one. Test as you go to ensure that each form imported works properly before importing the next. See if you can identify the culprit that way.

@George Hepworth 

Hi George

 

I found that opening each one in design view and saving again fixed the issue, now able to run front end on several pc's. 

absolutely stumped me what caused that.

thanks for replying. 

Make sure all the computers are running the exact same build no and bitness.

 

Have you tried decompiling your database?

Have you tried creating a new blank database and importing everything?