Solved

Front End - Sharing from Access 2016 W10 to Access 2013 W7

Posted on 2016-11-15
5
45 Views
Last Modified: 2016-11-15
Good morning,

I have a Front End File that I'm trying to share with a user who is running Access 2013 and Windows 7.  I have the Front End running on Access 2016  and Windows 10.  

I sent the file via email and then the user drags to her desktop and click to open and enables content.

When the user tries to open a form or print a report it just spins and then we have to End Task.  The Back End is on the Network and the Individual has access to the file, I've confirmed the Front End is Pointing at the Back End.

Any guidance would be greatly appreciated.
0
Comment
Question by:Aubie91
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 8

Accepted Solution

by:
Anders Ebro (Microsoft MVP) earned 500 total points
ID: 41887732
Have you set any additional references in your application?

E.g. a reference to the 2016 version of Excel?

On the users target machine, can you open the query/table to which the reports recordsource is bound?

Are both machines using the 32bit version of OFFICE? (Windows can be a different bitness)
0
 
LVL 84
ID: 41887804
In addition to Anders comments:

Have you created functionality to relink the Backend tables? Unless your environment exactly matches that of your users (in terms of Network resources, at least) you'll have to do that.

A caveat: You should always develop in the "lowest common denominator" when you must deal with mixed versions of Access. This means that any development work you do should be done in 2013. As Anders has indicated, you can have significant issues with mismatched references, invalid code, etc etc.
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 41887834
The other thing I tend to do when distributing a front end is to make sure that the links to the back-end tables use the fully qualified network path, not locally defined drive mapping.  If you do this, then the other user should not have to relink the tables as the will already have a path which is not specific to a particular computer.

Dale
0
 
LVL 1

Expert Comment

by:Peter Cole
ID: 41888124
Assuming you have tried the above. Try decompiling, compact and repair  then compile.

Check that your versions are all up to date using Microsoft Offcat

http://www.microsoft.com/en-us/download/details.aspx?id=36852

When run on my systems they are up to date but I receive a warning about a problem  wizard dll. I tried the suggested fix but that did not resolve it for me. I am not sure how relevant the warning is.
0
 

Author Closing Comment

by:Aubie91
ID: 41888812
Thanks to all for your recommendations.  The problem was we also had a link to SharePoint and the user was not logged in.  Once she logged into SharePoint the relationship was resolved and she was able to open forms.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question