Windows 10: Access database error

Discus and support Access database error in Windows 10 Software and Apps to solve the problem; I have an Access database, that I am running in Access from a O365 subscription. No one else accesses my database. I have a transaction function that... Discussion in 'Windows 10 Software and Apps' started by CharlesNailen, Sep 24, 2020.

  1. Access database error


    I have an Access database, that I am running in Access from a O365 subscription. No one else accesses my database. I have a transaction function that executes an update statement when the main form loads. After that, I cannot do anything because I get a "You do not have exclusive access to this database" error. What is weird is that if I look in my .laccdb file, before the update, there is one entry with my laptop name, and the user name is Admin. After the update, there is a second entry, again with my laptop name, but this time, the user is admin. What the heck? I have searched the Internet and everything I have found as to how to solve the problem is for shared databases, but this is not a shared database. I have included my function code below. Any help would be greatly appreciated.


    Update code:


    strDashboardSQLStatementsintDashboardSQLRecordCount = "UPDATE tbl_Dates SET tbl_Dates.Date_Inactive = -1 WHERE tbl_Dates.Course_Date < Date;"

    bolDashboardTransaction = Execute_TransactionstrDashboardSQLStatements, 1

    If bolDashboardTransaction = False Then

    DoCmd.Close acForm, "frm_Main_Dashboard"

    DoCmd.OpenForm "frm_Main_Dashboard"

    Exit Sub

    End If



    Function:

    Function Execute_TransactionByRef strDashboardSQLStatements, intDashboardRecordCount As Boolean
    DAO.DBEngine.BeginTrans

    On Error GoTo tranErr

    intDashboardLoopCounter = 0

    While intDashboardLoopCounter <= intDashboardRecordCount - 1

    CurrentDb.Execute strDashboardSQLStatementsintDashboardLoopCounter, dbFailOnError

    intDashboardLoopCounter = intDashboardLoopCounter + 1

    Wend

    DAO.DBEngine.CommitTrans

    Execute_Transaction = True

    Erase strDashboardSQLStatements

    Exit Function

    tranErr:

    Execute_Transaction = False

    DAO.DBEngine.Rollback

    strMessageBoxString = MsgBox"Transaction failed with Error: " & Err.Description, vbOKOnly, "Transaction Failed"

    Erase strDashboardSQLStatements

    End Function


    Thanks,

    Chuck Nailen

    :)
     
    CharlesNailen, Sep 24, 2020
    #1
  2. DRDNA Win User

    Recover access database

    Did you try this yet? http://support.microsoft.com/kb/283849

    Run the Compact and Repair utility. To do so, follow these steps:
    • If the database is open, close it.
    • On the Tools menu, point to Database Utilities, and then click Compact and Repair Database.
    • In the Database to Compact From dialog box, select the file that you want to compact, and then click Compact.
    • In the Compact Database Into dialog box, enter a new file name, and then click Save.

      If the compact and repair does not succeed, you will receive a message stating so. This means the damage is so severe that it cannot be corrected.
     
    DRDNA, Sep 24, 2020
    #2
  3. Recover access database

    HI,

    As Alexfranky suggested, These are some most common reasons due to which an access database file gets corrupted. Whenever you face corruption in your database files, you need to recover the your data and information from them. For more information visit :- Fix Corrupt Access Database using Compact and Repair
     
    Alex Franky, Sep 24, 2020
    #3
Thema:

Access database error

Loading...
  1. Access database error - Similar Threads - Access database error

  2. How to access an old WHS database.

    in Windows 10 Software and Apps
    How to access an old WHS database.: I have an old WHS server with a large database of archival files. This was the version where the database was separate from the backups so I just kept using it for file storage. Over time, the server has become invisible to other PCs on my network which are now Win10 and Win...
  3. Database / CRM / MS Access software

    in Windows 10 Software and Apps
    Database / CRM / MS Access software: I have some MS Access experience and I really like the whole "build your own form / database / app" flexible concept. The flaw with Access, in my opinion, is the license cost and not being able to host it online. Does anybody have any recommendation on similar software that...
  4. Database Exception error

    in Windows 10 Installation and Upgrade
    Database Exception error: Using Windows 10 I wrote a small database program a long while back and compiled it on Windows XP. I have been using it on Windows 7 after I installed the runtime. So, I installed the runtime on Windows 10. Still, I am getting this exception: ************** Exception...
  5. Updating database error

    in Windows 10 Drivers and Hardware
    Updating database error: I'd like to know why does it keep popping up that I need to fix database update error when I just got this CPU in May: It also had me doing update on certain social media apps on the daily. But yes, how do I update any database errors ( the simplest way please) on a Windows...
  6. database error

    in Windows 10 Installation and Upgrade
    database error: potential database error detected do troubleshoot does not fix problem https://answers.microsoft.com/en-us/windows/forum/all/database-error/a5ea2e20-50f2-4dcc-917c-be2eeae658d4
  7. Access database error "Unable to open connection to database" in Windows 10 only

    in Windows 10 BSOD Crashes and Debugging
    Access database error "Unable to open connection to database" in Windows 10 only: I have a Visual Studio application that was custom written many years ago for me. It uses the Microsoft Access database (.mdb). In all previous version of Windows (XP to 7) it functions perfectly, In Windows 10 I get an error message "Unable to open connection to database"....
  8. database error

    in Windows 10 Network and Sharing
    database error: Error Number: 42000/105 https://answers.microsoft.com/en-us/windows/forum/all/database-error/effb10bb-c088-4809-a681-9b841d24d4eb
  9. Access Database Problem

    in Windows 10 Software and Apps
    Access Database Problem: I am developing an Access database for a local charity which teaches people to use the internet. One field is a tick box flagging that the user is a Member. There are other categories of user (User, Tenant, One to One) and the charity later required a separate field listing...
  10. Running Access databases

    in Windows 10 Support
    Running Access databases: Hey guys, I hope I'm in the right section but, here's my problem. I bought this tablet with 10 already installed. I then installed Office 2007. OK no problem so far (my spreadsheets run fine). But then I transferred over a couple of my Access 2007 databases. Each seemed to...