delete query - "could not delete from specified tables"

[Mean Dean]

I have a problem with a delete query that yields a "could not delete from specified tables" error. The weird thing is that -- unlike all of the many web hits that I ran across attempting to solve this problem -- there aren't multiple "tables" involved at all! It is only deleting from one table.

The code (on Form_Unload) is, simply:

strSQL = "DELETE * FROM jctStudentPhone WHERE [StudentID] Is Not Null " & _
  "AND ([Phone] Is Null)"
DoCmd.RunSQL strSQL

The jctStudentPhone table doesn't have any relationships that would prevent a deletion. In fact, the whole thing runs fine for me. That brings me to the other piece of information here that is likely important, which is that it works on my computer (using admin account), but it doesn't work for another user who is using the program over a network. User-level security has been set up; however, the user for whom it doesn't work does have delete permission on jctStudentPhone.

Any ideas??

 

[Vassago]

You are sure that the user has read and write permission to the folder on the network the BE linked table is located in? Are there multiple users using the database and thus possibly locking records in that table that may prevent the query from running?

 

[Mean Dean]

You are sure that the user has read and write permission to the folder on the network the BE linked table is located in?

This was in fact the issue. A very, very belated thanks