Error 3008, need help!

[hermanko]

Hi,

I have a table called [Controlled Documents], and I have a form that is
kind of like a index or table of contents that displays only two fields
from that table (i.e. File Code and File Name). I have a command button
on this continuous form to allow user to open another form, that is
also based on the same table, but will display the rest of the fields
(i.e. created by, last modified, version, etc).

When i create the macro actions to close the first form and then open
the other form, i run into this error:

The table <name> is already opened exclusively by another user, or it
is already open through the user interface and cannot be manipulated
programmatically. (Error 3008)

My macro closes the first form, so I do not understand where I am going
wrong. Can anyone help me please?

Thanks!
Herman

 

[Wayne Morgan]

I would suspect that in either the form's properties or the properties of
the query the form is based on that the Record Locks has been set to All
Records and when you close the form, the at the timing is such that the
locks aren't released before you try to use the table again.

It sounds as if your first form is for display only, you won't be doing any
editing in that form. If so, try setting its recordset type to Snapshot and
the locks to No Locks. For normal usage, you shouldn't need to set locks.
Access will lock and edited record as it saves the changes. Setting the
option to Edited Record will lock the record being edited as soon as someone
starts to make a change to it until they commit the changes. With the No
Locks option, it two people try to edit the same record, Access will warn
the second person who tries to save changes that someone else changed they
record while they were editing it.

 

[hermanko]

Thanks Wayne

That was a quick fix and it makes sense.

Herman