Solved

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

Posted on 2016-11-15
5
49 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 85
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 48

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

717 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