Mahmoud Salem Mahmoud

One quite likely reason is that the user running the program doesn't have read-write access to the database file, especially if it is located in program files folder,make sure excel not mark as "Read Only" So check the directory and file permissions and moodify them if needed. You can also consider changing the location of the database file to another, more asily accessible folder.

In the VBA editor, put the following code in the "This Workbook" sheet: Private Sub Workbook_Open() MsgBox "I just opened my workbook" End Sub then save the workbook, close it, and open it again to see if this is what you want.