I have an access application that has linked sql server tables invoking a username and password. There is an event procedure on the opening form that has the following vba command.
DoCmd.OpenQuery "Delete_Outline_Codes"
DoCmd.OpenQuery "Append_Outline_Codes"
When I distributed the application to all the other users, its working fine for everyone except for one user. When this user opens the database; the message "Access database is read only access". Thenit gets stuck on that VB command since it is read only so I know it cannot delete or append a table. At first, I thought it might be the property or a permission issue. So I went ahead and made sure that he had admin rights and was the owner of the database. I did all that and then restarted and then it would work. As soon as he exits and tries to go back, the same read only message comes up. I made sure about the permission and he is admin. So it would work sometime but most of the time it would be read only and it would get stuck on the VB code to delete and append. Somebody have any suggestions!!
DoCmd.OpenQuery "Delete_Outline_Codes"
DoCmd.OpenQuery "Append_Outline_Codes"
When I distributed the application to all the other users, its working fine for everyone except for one user. When this user opens the database; the message "Access database is read only access". Thenit gets stuck on that VB command since it is read only so I know it cannot delete or append a table. At first, I thought it might be the property or a permission issue. So I went ahead and made sure that he had admin rights and was the owner of the database. I did all that and then restarted and then it would work. As soon as he exits and tries to go back, the same read only message comes up. I made sure about the permission and he is admin. So it would work sometime but most of the time it would be read only and it would get stuck on the VB code to delete and append. Somebody have any suggestions!!