+ Reply to Thread
Results 1 to 2 of 2

Problems connecting to an accdb database with the default encryption applied

  1. #1
    Registered User
    Join Date
    03-08-2022
    Location
    Winnipeg, Canada
    MS-Off Ver
    MS Office 2016 32 bit
    Posts
    1

    Question Problems connecting to an accdb database with the default encryption applied

    Hello,


    My problem has to do with how to connect to an accdb database that has a default encryption from 32 bit Microsoft Office Excel 2016. My current connection string is
    "Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\dataBase.accdb;Uid=Admin;Pwd=password;"

    This connection string works when the database is not encrypted on both 32bit and 64bit MS office Excel. It also works on 64bit when it is encrypted with the default encryption.
    However, when run on 32 bit with the default encryption I get the following error message:
    "[Microsoft][ODBC Microsoft Access Driver] General error Unable to open registry key Temporary (volatile) Ace DSN for process 0x5f08 Thread 0x2f94 DBC 0x256dbea4".

    From what I've read switching to a legacy encryption will likely solve the problem however, I believe my companies group policy object is currently preventing me from doing so and having it changed would be troublesome. So before I go down that route I am looking for alternative solutions or other possible causes for this issue.


    Thanks,
    Casandra

  2. #2
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    2,543

    Re: Problems connecting to an accdb database with the default encryption applied

    I don't feel like an ACC specialist, but I don't think there is any other way than to go back to a legacy encryption.

    Artik

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Using ADO/DAO in Excel 2013 to query an .accdb database hard crashes Excel
    By 1aaaaaaaaaaaaaaa in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-25-2015, 07:15 PM
  2. Problems connecting to MySQL Database
    By Wongadob in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-27-2014, 12:25 PM
  3. Setting default encryption
    By johncassell in forum Excel General
    Replies: 0
    Last Post: 01-22-2013, 09:49 AM
  4. problems connecting
    By FDibbins in forum The Water Cooler
    Replies: 11
    Last Post: 01-03-2013, 11:46 AM
  5. Replies: 9
    Last Post: 05-22-2012, 08:59 AM
  6. Trying to Open Database but Un Recognised File Extention .accdb
    By t0m46 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-18-2010, 01:43 PM
  7. [SOLVED] Can you change the default font applied to comments?
    By lizzym in forum Excel General
    Replies: 1
    Last Post: 01-11-2006, 01:20 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1