Forms!Please help

[Josh Hua]

I open a form which can be userd by many users at the
same time just
for viewing data. When I close the form, it keeps popping
out this
message "couldn't save; currently locked by user 'aaa' on
machine 'aaapc'. Then, I can not close the form. But if I
go to
design mode, I can close the form without any problems.
Please
advice. Thanks so much
Josh Hua

 

[John Vinson]

I open a form which can be userd by many users at the
same time just for viewing data.

Try setting the AllowUpdates property of the Form to False; if you're
using just for viewing data, it's not necessary for the form to be
updateable, and you'll avoid the message.

 

[Guest]

-----Original Message-----

False; if you're
using just for viewing data, it's not necessary for the form to be
updateable, and you'll avoid the message.


Try setting the AllowUpdates property of the Form to
.

Tried that, but still gave me the same error. I have
Access 97.

 

[John Vinson]

I open a form which can be userd by many users at the
same time just
for viewing data. When I close the form, it keeps popping
out this
message "couldn't save; currently locked by user 'aaa' on
machine 'aaapc'. Then, I can not close the form. But if I
go to
design mode, I can close the form without any problems.
Please
advice. Thanks so much
Josh Hua

This is very peculiar; if you're not trying to save data to the table,
you shouldn't get this error message!

Just how are you closing the form? With a command button, or the
builtin Windows "x" icon? And how are you opening the form - from the
forms window, or in code? If code in either case, please post the
code.