VBA Update Error 3218

[Bloren97]

Does anyone know exactly what this error means. I'm trying to update my database and I get this message in the title and "Currently Lock", "Cannot update" but when I hit OK.. I get "Update successful completed" Any help will be appreciated.
Thanks!

 

[Judith]

According to the help, this means that:

You tried to update data that is located on a page that is currently locked (for example by another user or by a form opened on your machine). In Access a page is a portion of the database in which record data is stored. Depending on the size of the records, a page may contain more than one record.

Possible causes:

- You tried to save a query that is being used by someone else. To save your query, wait for the other user to finish or enter a different name, and then try the operation again.
- You tried to use the Edit or Update method on a data page containing a record that is already open or locked.

Hope this helps,
Judith

 

[Bloren97]

Thanks so much!

But I found out that the server I was using ran out of RAM space while trying to update and it locked up the file.