Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Oct 2001
    Posts
    98
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Split database and .mdb and .accdb

    The backend of an Access 2010 database is a .mdb file and the frontend is an .accdb. Should this be a problem? We have used this database for a very long time with no problem in Windows XP and Windows 7. However a user opened it on a windows 8.1 laptop and got errors (VBA???) and then when we opened it in Windows 7 all of the buttons on the forms stopped working.

    What can I do? We only have a handful of Windows 8.1 users but lots of staff do use the Access databases.

    Thanks.

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    jfrasier,

    Did you make sure the Front End was loaded into a Trusted Location? Unless you have Signed your Macros with a digital certificate or you have changed the Access Macro settings to Allow All the VBA will not run in Office 2010 applications. HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    Star Lounger
    Join Date
    Oct 2001
    Posts
    98
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks. It has been working all along on computers with Windows 7. Perhaps the computer with Windows 8 needs to have the Access settings change.

    Thanks again.

    Jane

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •