newbie: Error 3008 on OpenRecordset

[Peter Schmitz]

Hi,

In my current form, I tried to open the table to read (and only read) some
values out of it by using the CurrentDb.OpenRecordset function in my
Form_Activate handler. Unfortunately, this results in error #3008: table
already opened exlusively by another user or GUI.
Is there any way around this? Is it possible to read some values out of a
table, that is exclusively opened by the overlying GUI? How exclusive is
exclusive?

Best regards,

Peter

 

[tina]

you could try working with the RecordsetClone property of the form, rather
than opening a recordset of the table.

hth