none
Networking Access on Windows 10 and Windows 7 RRS feed

  • Question

  • Having a problem with Access on a network with 2 computers - one running Windows 10, the other running 7.  The data files are on the computer running Windows 7.  Should there be any issues?
    Friday, July 28, 2017 4:26 PM

All replies

  • What kind of problem? Do you receive errors? If so, please provide details of the errors (screenshots are good). If not, please give more details of the problem.

    Is the database split into a Backend (tables only) and a Frontend (everything else)? If so, do all users have their own copy of the FE installed locally on their machine?

    Do other networking features seem to work? For example, can you browse the files on the Win7 machine from the Win10 machine? In order to share an Access database, all users must have sufficient permissions on the folder where your database is located (Read, Write, Update, and Delete).


    -- Scott McDaniel, Microsoft Access MVP

    Saturday, July 29, 2017 10:44 AM
  • Hi Timt,

    from your description , we are not able to find the problem. the information provided by you is not enough to reproduce the issue.

    provide sufficient information from that we can reproduce the issue. so that we can try to provide you the suggestion to solve the issue.

    Regards

    Deepak


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, July 31, 2017 1:16 AM
    Moderator
  • Hi,

    Other network functions are working properly. I am able to access and open the database from the Windows 10 computer by enabling active content.  (The files are stored on the Window 7 computer.)  After closing out of the program on 10 and trying to open it on the 7 computer, I get the prompt to enable active content.  I then get the following message:

    runtime error: 3085

    undefined function 'Date' in expression

    I believe the database is split into Frontend and Backend ("Client" and "Data").  I do not have a copy of anything other than the Office software installed on the Windows 10 computer.

    Tim

    Monday, July 31, 2017 5:04 PM
  • When you get an error about an internal function like Date() on one computer it usually means there is a reference missing (usually it's the DAO library). Go to the VBA editor. Clikc on Tools>References. The problem DLL will be marked as MISSING. Un check it and find the same named library in the list. It will have a higher or lower version, depending on which is installed.

    My guess is that the two systems do not have the same version of Office, thus the conflict in libraries. Develop on the lowest version. The higher version will know enough to compile the code using the library on hand.


    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    Monday, July 31, 2017 9:04 PM
  • Hi, thanks for your help.

    None of the libraries are marked as Missing.

    (The two systems do not have the same version of Office.)

    Tim

    Monday, August 7, 2017 5:23 PM
  • This sounds like your database directory is not a Trusted Location.  Did you create a Trusted Location entry for the database front-end (FE)?

    https://support.office.com/en-us/article/Create-remove-or-change-a-trusted-location-for-your-files-f5151879-25ea-4998-80a5-4208b3540a62#bm3


    Daniel Pineault, 2010-2017 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Monday, August 7, 2017 6:03 PM