Results 1 to 7 of 7
  1. #1
    rcrobman is offline Not Expert Yet!
    Windows XP Access 2007
    Join Date
    Apr 2011
    Location
    Toronto
    Posts
    73

    Bizarre behaviour of Access 2007 App running in Windows 10

    I have a Access 2007 app that is/has been developed on a Windows 2008 Server machine. The application runs fine on Windows XP and Windows 7 but exhibits some strange behaviour when run on Windows 10. One form has a subform on it that allows the user to enter data into it. When the form is opened up on WinXP or Win 7 it opens fine and the subform allows the user to edit/create new data records or change the data BUT when the form is opened up in Windows 10 the subform acts as if it is read-only - it will not allow data entry or changes - it is as if the open command used the acReadOnly descriptor which it does not do. The most interesting thing about this problem is the the form in question WAS NOT TOUCHED in the current version of the db app - in fact it hasn't been touched since WinXP was the development OS! I have tried making minor changes to the form to see if that would fix the problem when the form was recompiled but that has had no effect either!
    Does anyone have any suggestions for how to correct this - upgrading to Office365 would be a very expensive proposition as the entire company would have to upgrade and all of the Office 2007 Professional software products work just fine other than this one glitch with the Access 2007 application????

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    the windows version should not matter , very odd.
    I too have 2007 db and run it on various Windows without problems.
    Tho I dont think Ive tried Windows 10, so I cant test this. But the win version should not alter programming.

    for 'fun', you could try :
    If the pc only has Access 2007,
    1. downloading the latest Access runtime (its free), start the RT, open the app. See if that works.
    or
    2. find an old Access 2016 to install (some sell this)
    if it still wont work as a .mdb on Acc 2016, then convert it to 2016 .accdb.

    Does this happen on only 1 PC?
    are all the PCs in Win10?

    All versions of Access read all 2007 db just fine. (in my company)

  3. #3
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    When you installed Access on the Windows 10 box, did you go into Access and set the Trusted Location?

    To "Trust" your folder, click:

    • Office Button (top left)
    • Access Options (bottom of dialog)
    • Trust Center (left)
    • Trust Center Settings (button)
    • Trusted Locations (left)
    • Add new location (button)

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  4. #4
    rcrobman is offline Not Expert Yet!
    Windows XP Access 2007
    Join Date
    Apr 2011
    Location
    Toronto
    Posts
    73
    Thanks for the suggestions - appreciate the help!

  5. #5
    rcrobman is offline Not Expert Yet!
    Windows XP Access 2007
    Join Date
    Apr 2011
    Location
    Toronto
    Posts
    73
    Thanks for the help - I know that the Windows version shouldn't matter - will keep plugging away at it!

  6. #6
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Can you post a copy of the database (remove anything personal) and we don't need a lot of data.
    Enough data and the form/subform to highlight the problem.
    Better if you post in ZIP format.

  7. #7
    rcrobman is offline Not Expert Yet!
    Windows XP Access 2007
    Join Date
    Apr 2011
    Location
    Toronto
    Posts
    73
    Quote Originally Posted by orange View Post
    Can you post a copy of the database (remove anything personal) and we don't need a lot of data.
    Enough data and the form/subform to highlight the problem.
    Better if you post in ZIP format.

    Thanks for the offer of help - unfortunately I can''t post the db application as it belongs to a company that I do the work for.
    Appreciate the offer of help!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 06-05-2015, 10:00 AM
  2. Replies: 12
    Last Post: 02-09-2012, 02:27 PM
  3. Change in behaviour in Access 2007
    By Abacus1234 in forum Access
    Replies: 0
    Last Post: 12-13-2011, 03:44 PM
  4. Replies: 4
    Last Post: 09-06-2011, 05:11 AM
  5. Replies: 2
    Last Post: 08-29-2011, 03:36 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums