Database has been placed in - - Computer Learning Zone


	Back to Database has been placed in a state... Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Database has been placed in

Christopher Godfrey

2 years ago

I am receiving this error in my database..."Database has been placed in a state by user 'Admin' on machine 'Machine' that prevents it from being opened or locked."

I am using Access 365, and I am the only one working in the database. I am on a dedicated server with no other users. The folders are all "Trusted".

I did everything on the 8 point checklist shown in this forum, with no luck. I did create a new database and imported all the objects over successfully. It worked for a while and then I received the same error again. The fix was only temporarily.

Hopefully, someone can help me.

	Christopher Godfrey OP @Reply 2 years ago

	Sami Shamma @Reply 2 years ago
Are you by any chance opening more than one instance of Access?

	Christopher Godfrey OP @Reply 2 years ago
No. Just the one instance, and I rebooted the server twice.

Christopher Godfrey OP @Reply

2 years ago

I took Richard's advice and just started eliminating items and going through each of my backups. i discovered that the error was caused from the following code that i used to automatically update my BackEnd file.

Hopefully, someone can look at this code and tell me what it is in this code that is triggering that error. Answers and/or corrections would be appreciated.

Details

Option Compare Database

Option Explicit



Public Sub BackendOperations()



    Dim db As DAO.Database

    Dim backendPath As String



    ' Set the path to your backend database

    backendPath = "C:\DSBG-Dev\00_Access Databases\Frontend_BackEnd\BackEnd.accdb"  ' Replace with your actual path



    ' Open the backend database

    Set db = OpenDatabase(backendPath)



    ' Execute your existing code here

    'DoCmd.RunSavedImportExport "Import-EmployeeT"

    'DoCmd.RunSavedImportExport "Import-OrdersT"

   ' DoCmd.RunSavedImportExport "Import-TekionSalesT"



    ' Close the backend database

    

    db.Close

    

    Set db = Nothing



End Sub

	Richard Rost @Reply 2 years ago
Why don't you just attach to those tables directly and then run a simple query to update the data? There's no need to connect to it that way. Basically, your front end is trying to open that database back end, and then you're trying to open a second copy, and it's conflicting.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Database has been placed in a state....

Next Unseen

New Feature: Comment Live View